Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ :

vs2008Á¬½Óoracleʱ±¨´í

System.Data.OracleClient ÐèÒª Oracle ¿Í»§¶ËÈí¼þ 8.1.7 »ò¸ü¸ß°æ±¾
ÎÒÔÚÆäËûÏîÄ¿ÖпÉÒÔÕý³£Á¬½ÓµÄ£¬ÍøÉϵķ½·¨¶¼ÊÇ˵ȨÏÞʲôµÄ
²»Çå³þ~ ²»²»ÖªµÀÄãµÄ ´úÂëÊÇÔõôдµÄ

Oracle°²×°Îļþ¼Ð,¿ªÆôIUser_*Óû§ËùÓÐȨÏÞ

²Î¿¼FortuneBase
²Î¿¼µØÖ·www.cnblogs.com/mail-ricklee

ÕâÊÇÎÒÔÚ·þÎñ³ÌÐòÀïµÄ¼ÆÊ±Æ÷Àï ......

OracleÇóÒ»¼òµ¥¹ý³Ì

Ò»¸ö¹ý³Ì´ø²ÎÊý£¬´«¹ýÀ´µÄ²ÎÊýÊ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 °²×°

¸÷λÉñ£¬Ë­ÄܸøÎÒµã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 ......

Îʼ¸¸öoracle²Ù×÷µÄÎÊÌâ

°³ÊÇMS SQLÄÇСºúͬÀï×ß³öÀ´µÄ£¬ËùÒÔľÓÐÁ˽çÃæ£¬oracleµÄÄÇЩÃüÁîÓÖ²»Ê죬¾Í²»ÖªµÀ¸ÃÈçºÎʹÓÃÕâ¸ö¶«¶«ÁË¡£
Çë½Ì¼¸¸ö³£ÓõIJÙ×÷£¬ÎÒÔÚwindowsµÄcmdÃüÁîÀï²Ù×÷µÄ£º
1.µÇ½sqlplusµÄʱºò£¬ÉÏÀ´¾ÍÈÃÊäÈëÓû§Ãû£¬¿ÉÊÇÎÒÔõô֪µÀÕâÊǵǽµÄÄǸöÊý¾Ý¿âʵÀý£¿°²×°Ê±µÄorcl»¹ÊǺóÀ´×Ô¼º½¨Á¢µÄÆäËûÊý¾Ý¿âʵÀý£¿
2.ÎÒÔÚsqlpl ......

oracle²é詢橫Ïò顯ʾ

請½Ì¸ßÊÖ
現ÔÚÓÐ幾個×Ö¶ÎÈçÏÂ
課³Ì號  ÉÏ課時間
  123    2009/1/8
  1234    2009/1/9
現ÔÚÎÒÏë讓Æä顯ʾ¸ñʽÈçÏÂ
課³Ì號    123      1234
É ......

oracle Èý±íÁ´½Ó²éѯÎÊÌâ

table a£»             
userid               
  1
  2
  3
  5

table b£»
userid
  1
  2
  3
  5

table c£»
userid
  2
  ......
×ܼǼÊý:27572; ×ÜÒ³Êý:4596; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [1742] [1743] [1744] [1745] 1746 [1747] [1748] [1749] [1750] [1751]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ