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

Âé·³´óÏÀ½²½âÒ»ÏÂoracle µÄÓï·¨ÎÊÌâ лл£¡

1 connect_by_root ÊDz»ÊÇÒ»¸ö¹Ø¼ü×ÖÄØ£¿

2 start with  connect by prior ÊÇÁ¬×ÅÓõÄô£¿

3 insert into ±íÃû with ... as ...

ÒÔÉÏ 3 ¸ö ÊÇʲôÒâ˼ ÈçºÎÓÃÄØ£¿Âé·³¾Ù¸ö¼òµ¥»ù±¾µÄÀý×Ó˵Ã÷һϰɡ£
1£¬connect_by_root ÊDz»ÊÇÒ»¸ö¹Ø¼ü×ÖÄØ£¿

connect_by_rootÊÇ10gµÄÓ÷¨,Èç¹ûÖ»ÊÇÈ¡id  =  4  µÄ×îÉϲãÇ×id  £¬²»ÓÃconnect_by_rootÒ²ºÜÈÝÒ×°ìµ½£¬Ö»ÊÇÈç¹ûÒª°ÑËùÓÐidµÄ×îÉϲãid¶¼ÁгöÀ´£¬¾ÍÒªÓÃconnect_by_rootÁË£¬ÎÒÕâÀïû»·¾³£¬Ò²²»ºÃ²âÊÔ£¬ÎÒÏë×îºó½á¹ûÓ¦¸ÃÊÇÕâÑùµÄ 
            Ç×ID    ×ÓID    ×îÉϲãÇ×id 
              1            2            1 
              2            3            1 
              3            4            1 
              6            5            7 
              7            6            7   
  Õâôд²»ÖªµÀÐв»ÐУ¬Äã¿ÉÒÔÊÔÊÔ£¬ÎÒÕâÀïû²âÊÔ»·¾³,Ó÷¨¾ÍÕâÑùÁË£¬


Ïà¹ØÎÊ´ð£º

PHP Á¬½ÓOracle ³ö´í

<?php
  getenv("ORACLE_HOME");
  $conn=ocilogon("test","test","test_db");
  if($conn)  
  echo success;  
&nb ......

¼±Ñ°Oracle ERPʵʩ¹ËÎÊ

3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾­Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£

ûÓÐORACLE ERPµÄ¾­Ñé,ÓÐÓÃÓѺÍTIPTOP¾­Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......

oracleÈëÃÅÅäÖÃ

oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
  (SID_LIST =
  ......

¹ØÓÚoracle 10gµÄsqlplus

ÏÖÔÚÎÒ±¾µØÃ»Óа²×°oracle, µ«plsqldevÐèÒªsqlplus.exeµÈ£¬ÇëÎÊoracle10gÔÚwindowsÐèÒª
ÄÄЩexeÎļþ£¬ÄÄλ´ó¸çÄÜ˳±ãÌṩһÏÂQQ£º190565390

×°oracleµÄʱºò¿ÉÒÔÑ¡ÔñÖ»×°¿Í»§¶ËµÄ

×îÆðÂëҪװoracle£¬ÄãÖ»Ðè×°¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ