²»Óð²×°Oracle ClientÈçºÎʹÓÃPLSQL Developer
²»Óð²×°Oracle ClientÈçºÎʹÓÃPLSQL Developer
1. ÏÂÔØoracleµÄ¿Í»§¶Ë³ÌÐò°ü£¨30M£©
Ö»ÐèÒªÔÚOracleÏÂÔØÒ»¸ö½ÐInstant Client PackageµÄÈí¼þ¾Í¿ÉÒÔÁË£¬Õâ¸öÈí¼þ²»ÐèÒª°²×°£¬Ö»Òª½âѹ¾Í¿ÉÒÔÓÃÁË£¬ºÜ·½±ã£¬¾ÍËã֨װÁËϵͳ»¹ÊÇ¿ÉÒÔÓõġ£
ÏÂÔØµØÖ·£ºhttp://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html
½âѹµ½Ò»¸öĿ¼Öм´¿É£¬ÀýÈçc:\oracleclient
2. ÅäÖòÙ×÷ϵͳ»·¾³±äÁ¿
NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
TNS_ADMIN=C:\oracleclient
3. ÅäÖÃÁ¬½ÓOracleµÄÅäÖá£tnsnames.oraÎļþµ½Ä¿Â¼C:\oracleclient¡£¿ÉÒÔ´Óoracle·þÎñÆ÷¿½±´Ò»¸ö¹ýÀ´¡£
ÄÚÈÝÀàËÆ£º
# tnsnames.ora Network Configuration File: E:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCLProduct =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = prmpatm1.asiapacific.hpqcorp.net)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
ORCL122 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 16.157.133.122)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
4. °²×°PLSQL Developer
5. ÅäÖÃPLSQL Developer£¨µÚÒ»´Î¿ÉÒÔ²»ÓõǼֱ½Ó½øµ½PLSQL Developer£©
Tools --> Preferences--> Connections,
Oracle HomeÄÚÈÝΪ C:\oracleclient
OCI libraryÄÚÈÝΪ C:\oracleclient\oci.dll
ÖØÐÂÆô¶¯PLSQLDeveloper
Íê±Ï
Ïà¹ØÎĵµ£º
Ê×ÏÈ£¬ÄãÒªÓÐÒ»ÕÅ±í£¡
CREATE TABLE example(
ID Number(4) NOT NULL PRIMARY KEY,
NAME VARCHAR(25 ......
×î½ü·¢ÏÖÒ»¸ö±È½ÏÓÐÒâ˼µÄÎÊÌ⣺
µ±ÎÒÃÇÔÚÖ´ÐÐÒ»Ìõ²éѯÓï¾äʱ£¬Èç¹ûÌõ¼þν´ÊÖк¬Óк¯Êý£¬Èç abs(age)<10£¬´Ëʱ£¬Í¨¹ý²éѯ¼Æ»®¿´µ½µÄ½á¹û¼¯µÄ»ùÊýÖµÓëʵ¼ÊµÄÖµÏà²îºÜ´ó¡£µ±ÎÒÃǸıä²éѯÌõ¼þʱ£¬Èçabs(age)<20£¬ÕâʱµÄ»ùÊýÖµ²»»á¸Ä±ä£¬ºÍabs(age)<10µÃµ½µÄ»ùÊýÖµÒ»Ñù¡£
µ«ÏÖÔÚ»¹Ã»ÕÒµ½ÎÊÌâµÄÔÒò£¬searching... ......
ÔÚOracleÊý¾ÝµÄ´æ´¢ÖУ¬¿ÉÒÔ°Ñ´æ´¢¿Õ¼äÏëÏóΪһ¸öË®¿â£¬Êý¾ÝÏëÏóΪˮ¿âÖеÄË®¡£Ë®¿âÖеÄË®µÄλÖÃÓÐÒ»ÌõÏß½Ð×öˮλÏߣ¬ÔÚOracleÖУ¬ÕâÌõÏß±»³ÆÎª¸ßˮλÏߣ¨High-warter mark, HWM£©¡£ÔÚÊý¾Ý¿â±í¸Õ½¨Á¢µÄʱºò£¬ÓÉÓÚûÓÐÈκÎÊý¾Ý£¬ËùÒÔÕâ¸öʱºòˮλÏßÊǿյģ¬Ò²¾ÍÊÇ˵HWMΪ×îµÍÖµ¡£µ±²åÈëÁËÊý¾ÝÒԺ󣬸ßˮλÏ߾ͻáÉÏÕÇ£¬µ«ÊÇÕâ ......
ÔÚoracleÖУ¬ÎÒÃÇʹÓÃin·½·¨²éѯ¼Ç¼µÄʱºò£¬Èç¹ûinºóÃæµÄ²ÎÊý¸öÊý³¬¹ý1000¸ö£¬ÄÇô»á·¢Éú´íÎó£¬ÏÂÃæµÄÕâ¸ö·½·¨¾ÍÊǽâ¾öÕâ¸öÎÊÌâµÄ£¬Ëü½«ÎÒÃǵÄÉÏǧ¸ö²ÎÊý·Ö³É¼¸×飬±£Ö¤Ã¿×éµÄ²ÎÊý¸öÊý²»³¬¹ý1000
/**
* Éú³É·ûºÏÌõ¼þµÄsqlÓï¾ä,½â¾öinÎÊÌâ
* @param sqlParam£ºÎÒÃÇÐèÒª´¦ÀíµÄ²ÎÊýµÄ×Ö·û´®¸ñʽ£¬ÀýÈ ......