Âé·³´óÏÀ½²½âÒ»ÏÂ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
getenv("ORACLE_HOME");
$conn=ocilogon("test","test","test_db");
if($conn)
echo success;
&nb ......
3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£
ûÓÐORACLE ERPµÄ¾Ñé,ÓÐÓÃÓѺÍTIPTOP¾Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......
oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
......
ÏÖÔÚÎÒ±¾µØÃ»Óа²×°oracle, µ«plsqldevÐèÒªsqlplus.exeµÈ£¬ÇëÎÊoracle10gÔÚwindowsÐèÒª
ÄÄЩexeÎļþ£¬ÄÄλ´ó¸çÄÜ˳±ãÌṩһÏÂQQ£º190565390
×°oracleµÄʱºò¿ÉÒÔÑ¡ÔñÖ»×°¿Í»§¶ËµÄ
×îÆðÂëҪװoracle£¬ÄãÖ»Ðè×°¿ ......