Á¬½ÓÆäËû»úÆ÷µÄoracle.
LY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.251)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ly)
)
)
ÕâÊDZðÈ˸øÎÒµÄһЩÅäÖÃÐÅÏ¢£¬ÎÒÏëÁ¬µ½192.168.0.251Õą̂»úÆ÷µÄÊý¾Ý¿â£¬ÎÒµÄoracle°æ±¾ÊÇ10G£¬ºÜ¾ÃûÓùýoracleÁË£¬Âé·³²½ÖèÏêϸһµã£¬Ð»Ð»
½«ËüÃÇÌí¼Óµ½%oracle_home%\NETWORK\ADMINϵÄtnsnames.oraÎļþÖÐ
µÇ¼µÄʱºòÊäÈëÓû§ÃûÃÜÂëºó£¬¿âÃûÌîly
¶ÔµÄ
Ò²¿ÉÒÔʹÓÃͼÐι¤¾ßnet manager
net·þÎñÃû£ºLY£¨Ëæ±ãÌîÒ»¸ö¶¼¿ÉÒÔ£©
Ö÷»úÃû£º192.168.0.251
Oracle·þÎñÃû£ºly
Á¬½ÓµÄʱºòҪעÒ⽫windows·À»ðǽ¹Ø±Õ
1¡¢¿ªÊ¼-->oracle-->¼¯³ÉÅäÖùÜÀí-->net manager
2¡¢Ìí¼ÓÍøÂçÅäÖÃ
3¡¢Êý¾Ý¿âʵÀýÃûLY
4¡¢Ä¬ÈÏÁ½²½
5¡¢ÊäÈëÒªÁ¬½ÓµÄipµØÖ·£º192.168.0.251
6¡¢×¢Ò⣺LY_192.168.0.251
7¡¢Íê³É
×¢Ò⣺×îºÃÊÇÓÃÕâ¸ö¿ÉÊÓ»¯½çÃæÀ´ÅäÖ㬶ø²»Òª×Ô¼ºÈ¥ÐÞ¸Ätnsname.oraÎļþ
Ïà¹ØÎÊ´ð£º
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
±í×Ö¶Î
ID NAME TIME AMOUNT
14502 1111 0201 1
14502 1111 0201 5
14 ......
ÏÂÃæÕâ¶Î»°:
¿Í»§ÖÕ¶Ë×Ö·û¼¯£¬nls_lang»·¾³±äÁ¿×Ö·û¼¯£¬Êý¾Ý¿âʹÓõÄ×Ö·û¼¯¡£ÆäÖУ¬¿Í»§Öն˸÷ÖÖ¸÷Ñù£¬±ÈÈçwindowsÏÂcmd£¬unix/linuxÏÂterminal/console,ÉõÖÁÈçtoadµÈ¹¤¾ßÒ²¿ÉÒÔÀí½âΪһ¸öÖÕ¶Ë¡£ÎÒÃÇʹÓÃwindows ......
ÄÄλÐÖµÜÓÐoracle cartradge¿ª·¢×ÊÁÏ£¬Äܲ»Äܹ²Ïíһϣ¿Ð»Ð»£¡
ûÓÐÌý˵¹ý£¬OracleÌ«ÅÓ´óÁË
ÎÒÒ²ÊǸսӴ¥£¬²»Çå³þÔõô×ö£¬Ö»ÖªµÀÕâ¸ö¼¼ÊõÊÇÓÃÀ´¿ª·¢Öмä¼þµÄ
End_rbody_60301247//-->
¸Ã»Ø¸´ÓÚ2009-1 ......