Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Á¬½ÓÆäËû»úÆ÷µÄ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

ÒýÓÃ
½«ËüÃÇÌí¼Óµ½%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Îļþ

ÒýÓÃ
1¡¢¿ªÊ¼-->oracle-->¼¯³ÉÅäÖùÜÀí-->net manager
2¡¢Ìí¼ÓÍøÂçÅäÖÃ
3¡¢Êý¾Ý¿âʵÀýÃûLY
4¡¢Ä¬ÈÏÁ½²½
5¡¢ÊäÈëÒªÁ¬½ÓµÄipµØÖ·£º192.168.0.251
6¡¢×¢Ò⣺LY_192.168.0.251


Ïà¹ØÎÊ´ð£º

ORACLEÊý¾Ý¿âÖÐµÄ group by Óï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

ORACLE È¡×î´óÖµ

±í×Ö¶Î

ID      NAME    TIME    AMOUNT

14502  1111    0201    1
14502  1111    0201    5
14 ......

¹ØÓÚORACLE×Ö·û¼¯

ÏÂÃæÕâ¶Î»°:
¿Í»§ÖÕ¶Ë×Ö·û¼¯£¬nls_lang»·¾³±äÁ¿×Ö·û¼¯£¬Êý¾Ý¿âʹÓõÄ×Ö·û¼¯¡£ÆäÖУ¬¿Í»§Öն˸÷ÖÖ¸÷Ñù£¬±ÈÈçwindowsÏÂcmd£¬unix/linuxÏÂterminal/console,ÉõÖÁÈçtoadµÈ¹¤¾ßÒ²¿ÉÒÔÀí½âΪһ¸öÖÕ¶Ë¡£ÎÒÃÇʹÓÃwindows ......

oracle cartridge¿ª·¢

ÄÄλÐÖµÜÓÐoracle cartradge¿ª·¢×ÊÁÏ£¬Äܲ»Äܹ²Ïíһϣ¿Ð»Ð»£¡

ûÓÐÌý˵¹ý£¬OracleÌ«ÅÓ´óÁË

ÎÒÒ²ÊǸսӴ¥£¬²»Çå³þÔõô×ö£¬Ö»ÖªµÀÕâ¸ö¼¼ÊõÊÇÓÃÀ´¿ª·¢Öмä¼þµÄ



End_rbody_60301247//-->
¸Ã»Ø¸´ÓÚ2009-1 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ