ÈçºÎ´ÓOracleÖлñÈ¡¶ÔÏóÐÅÏ¢£¿
ÎÒÏë²éѯÁеÄÈçÏÂÐÅÏ¢£º
ÊÇ·ñΪÖ÷¼ü ÊÇ·ñ¿ÉΪ¿Õ ÊÇ·ñΨһ Ãû³Æ Êý¾ÝÀàÐÍ ³¤¶È ĬÈÏÖµ
ÇëÎʸÃÔõôд£¿
ÎÒÏë²éѯº¯Êý¼°´æ´¢¹ý³ÌµÄ´úÂ룬¸ÃÔõôд£¿
¸öÈËÈÏΪȥOracle×¨ÇøÎʵϰ£¬´ð°¸³öµÃ¿ì....
´¿°ï¶¥£¬Ó¦¸ÃÖ»ÊÇÄÚ²¿º¯Êýµ÷ÓõÄÎÊÌâ°É..
лÁË£¬
ÉÏ´ÎÓиöÎÊÌâÁ½±ß¶¼ÎÊÁË£¬½á¹û»¹ÊÇÕâ±ßºÃЩ¡£
µ«¶ÔOracle²»Êìѽ¡£
OracleÖвéѯ±í×ֶλù±¾ÐÅÏ¢¡¢Ö÷¼ü¡¢Íâ¼ü
ÕâÑùµÄÎÊÌâ ×Ô¼ºÏÈgoogle °Ù¶ÈÏÂ
˳±ãÎÊÏ£¬ÔõôֹͣÒÔÐéÄâĿ¼·½Ê½ÔËÐеÄAsp.netÓ¦ÓóÌÐò(¼´ÍøÕ¾)£¿
²»ÊÇÄÇÖÖͨ¹ýÐÞ¸ÄÄÚÈݺóÖØ±àÒëµ¼ÖÂIISÖØÆôAsp.netÓ¦ÓóÌÐòµÄ·½Ê½£¬ÊÇ´¿ÊÖ¶¯µÄ£¬¾ÍÏñÎÒÃÇÓÒ¼üĬÈÏÍøÕ¾µãÍ£Ö¹µÄÄÇÑù¡£
connect ¶ÔÏóµÄ GetSchema º¯Êý, »ñÈ¡¸÷ÖÖÊý¾Ý¿âÔªÐÅÏ¢,
Ïêϸ¿´ msdn .
ÔõÑù´Ó Oracle ÖлñÈ¡º¯ÊýÃû£¬´æ´¢¹ý³ÌÃû¼°ËûÃǵĴúÂ룬¾ÍÏñÔÚSqlÖÐÄÇÑù½«´úÂëÈ¡³öÀ´¡£
£¿£¿
ûÈ˻ظ´Âð£¿
ÓÖ³ÁÁË£¿
Ïà¹ØÎÊ´ð£º
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É
SQL> select name from v$database;
NAME
---------
ORCL
......
ÓÐ500ÍòÌõͨ»°¼Ç¼
±àºÅ ºÅÂë ±»½ÐºÅÂë ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä ͨ»°Ê±³¤
1 10010 20020 12:00 12:01 ......
Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......
ÎÊÌâÃèÊö£º
1¡¢¼ÙÉèÓбí
t1±í£¬°üº¬ËÄÁÐ
s1 a b c
1 a a a
2 b b b
.........
t2±í£¬°üº¬2ÁÐ
s2 ff
1 77
2 88
............
ÈçºÎÉú³ÉÕâÑùµÄºÏ²¢Ê ......