System.Data.OracleClient ÐèÒª Oracle ¿Í»§¶ËÈí¼þ 8.1.7 »ò¸ü¸ß°æ±¾
ÎÒÔÚÆäËûÏîÄ¿ÖпÉÒÔÕý³£Á¬½ÓµÄ£¬ÍøÉϵķ½·¨¶¼ÊÇ˵ȨÏÞʲôµÄ
²»Çå³þ~ ²»²»ÖªµÀÄãµÄ ´úÂëÊÇÔõôдµÄ
Oracle°²×°Îļþ¼Ð,¿ªÆôIUser_*Óû§ËùÓÐȨÏÞ
²Î¿¼FortuneBase
²Î¿¼µØÖ·www.cnblogs.com/mail-ricklee
ÕâÊÇÎÒÔÚ·þÎñ³ÌÐòÀïµÄ¼ÆÊ±Æ÷Àï ......
Ò»¸ö¹ý³Ì´ø²ÎÊý£¬´«¹ýÀ´µÄ²ÎÊýÊDzéѯ±íÃûµÄÒ»²¿·Ö£¬ÎÒ²»ÖªµÀ±äÁ¿ºÍ×Ö·û´®Ôõô½ÓºÏ
¾ÙÀýÈçÏ£º
SQL code:
declare
v_sql varchar2(200);
v_table_name varchar2(20) :='test';
begin
v_sql:=[color=#FF0000]'select * from '||v_table_name||''[/color];
execute immediate v_sql;
dbms_output.put_line(v_sql); ......
¸÷λÉñ£¬ËÄܸøÎÒµãOracle 11g°²×°µÄ×ÊÁÏ£¡Íò·Ö¸Ð¼¤°¡£¡±¾ÈËÓÊÏäshuhujiaolong@163.com
¹ÙÍøÓаɣ¿
oracle Êý¾Ý¿âÎĵµ
http://www.oracle.com/technology/global/cn/documentation/database.html
ÕâÀï¸üÇå³þ£º
http://www.oracle.com/technology/global/cn/getting-started/coredba.html
windo ......
°³ÊÇMS SQLÄÇСºúͬÀï×ß³öÀ´µÄ£¬ËùÒÔľÓÐÁ˽çÃæ£¬oracleµÄÄÇЩÃüÁîÓÖ²»Ê죬¾Í²»ÖªµÀ¸ÃÈçºÎʹÓÃÕâ¸ö¶«¶«ÁË¡£
Çë½Ì¼¸¸ö³£ÓõIJÙ×÷£¬ÎÒÔÚwindowsµÄcmdÃüÁîÀï²Ù×÷µÄ£º
1.µÇ½sqlplusµÄʱºò£¬ÉÏÀ´¾ÍÈÃÊäÈëÓû§Ãû£¬¿ÉÊÇÎÒÔõô֪µÀÕâÊǵǽµÄÄǸöÊý¾Ý¿âʵÀý£¿°²×°Ê±µÄorcl»¹ÊǺóÀ´×Ô¼º½¨Á¢µÄÆäËûÊý¾Ý¿âʵÀý£¿
2.ÎÒÔÚsqlpl ......
請½Ì¸ßÊÖ
現ÔÚÓÐ幾個×Ö¶ÎÈçÏÂ
課³Ì號 ÉÏ課時間
123 2009/1/8
1234 2009/1/9
現ÔÚÎÒÏë讓Æä顯ʾ¸ñʽÈçÏÂ
課³Ì號 123 1234
É ......
table a£»
userid
1
2
3
5
table b£»
userid
1
2
3
5
table c£»
userid
2
......