±³¾°£º
ÓÐÁ½¸öÊý¾Ý¿âAºÍBÐèÒª½»»»Êý¾Ý£¬ÔÚÊý¾Ý¿âAÖн¨Á¢dblinkµ½Êý¾Ý¿âB£¬²¢ÔÚÊý¾Ý¿âAÖн¨Á¢Êý¸öprocedure£¨ÓÃÓÚͬ²½Êý¾Ý£©£¬ÔÚunixÏÂʹÓÃshell½Å²½¶¨Ê±µ÷ÓÃprocedure¡£
ÍøÂç»·¾³£ºÊý¾Ý¿âBÊÇÍⵥλµÄ£¬ÓëÊý¾Ý¿âAËùÔÚµÄÍøÂçʹÓÃרÏßÁ¬½Ó
ÎÊÌ⣺
ÒòΪÊý¾Ý¿âBÊÇÍⵥλµÄ£¬Èç¶Ô·½Í£»úά»¤»òÕßÊÇÊý¾Ý¿â·¢Éúå´»ú£¬ÊÇ·ñ»áµ¼ÖÂÊ ......
Ò³ÃæÉÏÓиöÊ÷×´½á¹¹Í¼£¬ÆäÊý¾ÝÔÚÊý¾Ý¿âÀï´æ´¢£¬ÓÐÁ½¸öÖØÒªµÄ×ֶΠcode ºÍ parentCode£¬ÆäÖÐcodeΪ×Ô¼ºµÄ´úÂëºÅ£¬parentCodeÖ¸Ïò¸¸¼¶¡£
ÏÖÔÚÒªÇóÓÃsql½Å±¾£¬ÔÚÊý¾Ý¿âÀォÆäÖÐÒ»¸öÊý¾Ý¼°Æä×ÓËïÊý¾Ý¶¼É¾³ý£¬
Âé·³ÄÄλ¸ßÊÖ°ï¸öæ¡£¡£¡£¡£
´ó¼Ò¶¼À´¹Øעϡ£¡£¡£¡£
ллÄãµÄ°ï棬ÄãÄܸæËßÎÒ start with code=? connect b ......
Êý¾ÝÔ´Ãû³Æ Oradata Óû§Ãû£ºuser ÃÜÂëpassword ·þÎñÆ÷IP 10.160.25.15
±¾»úÉÏ°²×°ÁËoracleµÄ¿Í»§¶Ë£¬Í¨Ñ¶²âÊԳɹ¦
ÇóaspÁ¬½ÓoracleÊý¾Ý¿â´úÂ룬лл°¡£¡
<%
set conn=server.createobject("adodb.connection")
newconn="Provider=OraOLEDB.Oracle.1;User ID=user;Password= ......
ÎÒÔÚLinuxÉÏÏȵǼΪoracleÓû§ºó£¬ÔÙÖ´ÐÐsqlplus '/as sysdba'ʱ±¨´í£¬
SQL*Plus: Release 10.2.0.4.0 - Production on ÐÇÆÚÈý 4ÔÂ 21 16:29:38 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
ERROR:
ORA-01031: insufficient privileges
Enter user-name:
È»ºóÎÒÔÚuser-name:ºóÃæÊäÈëÊý¾Ý¿ ......
SQL code:
SQL Statement from editor:
select c0602 "ÉÌÆ·±àÂë",c0625 "ÉÌÆ·ÌõÂë",
c0103 "ÉÌÆ·Ãû³Æ",c0104 "¹æ¸ñ",c0604 "Åä»õ¼þÊý",
c0605 "Åä»õÊýÁ¿",c0618 "¼Æ»®ÔùÆ·Êý",c0606 "ʵ¼Ê³ö¿âÊý",
c06 ......
¸÷λ´óÏÀ£º´ó¼ÒºÃ£¡×î½üÏëÉîÈëѧѧOracle£¬ÓÐûÓÐʲô°ïÖúÎĵµ»òÕßѧϰ×ÊÁÏʲôµÄ·ÖÏíÏ¡££¨½éÉÜOracle»úÖƵģ¬ÉîÈëЩµÄ£¬»ù±¾×ÊÁÏÎÒÓУ©
Çë·¢µ½ÎÒµÄÓÊÏ䣬jzd870318@163.com£¬²»Éõ¸Ð¼¤..
www.itpub.netÉÏÓкܶà.
ѧϰOracle ×îºÃµÄÎĵµ¾ÍÊÇ ¹Ù·½ÏÂÔØµÄ document ,
¸Õ¿ªÊ¼¾Í¿´¿´ <Oracle 10g ÈëÃÅÓë»ù´¡&g ......