Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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
 ×îÐÂÎÄÕ : Oracle

oracle°²×°ÎÊÌâ

1.
  ÔÚ°²×°µÄʱºò°²×°µÄoracle 9i release¡£¡£¡£ÊÇ·ñÓ¦¸Ã°²×°Õâ¸ö°æ±¾£¬ÔÙ°²×°¹ý³ÌÖгöÏÖoracle net configuration assistantÅäÖÃÄ£¿é£¬ÊäÈëÖ÷»úºÅºÍ¶Ë¿ÚºÅÒÔ¼°sll¶Ë¿ÚºÅ£¬²»ÖªµÀÊÇʲôÎÊÌâ¡£

2.
  SQL*Plus: Release 9.2.0.1.0 - Production on ÐÇÆÚÁù 9ÔÂ 26 16:58:03 2009

  Copyr ......

oracle Á¬½ÓµÄÎÊÌâ

Óö¼ûÁËÒ»¸öÕâÖÖÇé¿ö    A  ÔÚÄÚÍø  B ÓÐÄÚÍøºÍÍâÍøµÄÍø¿¨  C  ΪÍâÍø 

Oracle Server ×°ÔÚAÀï    ÏÖÔÚÖ»Äܱ»B·ÃÎÊ 

ÏëÇëÎʸ÷·¸ßÊÖ  ÄÜ·ñ½«B ×öÒ»¸öÀàËÆAdapter µÄ¶«Î÷ 

¼´  ÎÒʹÓà C  ½«B ×ö³ÉÖÐת  À´· ......

oracle²éѯÎÊÌâ

ÎÒÒª²éѯµ±Ç°Óû§µÄËùÓбíÒÔ¼°±í×¢Ê͵ÄsqlÓ¦¸ÃÔõôдÄØ

select table_name,comment from user_tables

´ó¼Ò°ïÎÒ¿´¿´ÕâÌõsql´íÔÚÄÄÀï
user_tablesÀïûÓÐcomment×Ö¶Î
Ïë¿´×¢Ê͵Ļ°
select * from user_tab_comments


SQL code:
SQL> select a.table_name,b.comments
2 from user_tables a ......

ÇóÖú£¬Oracle¼àÌýµÄÎÊÌâ

RTÎÒÓõÄÊÇOracle9iµÄÊý¾Ý¿â£¬Á¬½Ó±¾µØµÄOracleûÓÐÈκÎÎÊÌ⣬µ«ÊÇÎÒÁ¬½ÓÆäËû»úÆ÷µÄOracleµÄʱºò×ÜÊDZ¨³öûÓÐûÓмàÌýÆ÷ÕâÊÂÔõô»ØÊ£¬¼àÌýÄÇЩ¶«Î÷¶¼ÊÇÆô¶¯Á˵ġ£¡£¡£

¼àÌý¶Ë¿Ú¶ÔÉÏû£¿

ÓÃeasy connect³¢ÊÔһϣº
SQL code:

sqlplus /nolog
conn user/password@'target_host_or_ip:port_number/instance_n ......

ORACLE ×ÜºÍ SUM ÎÊÌâ

±ÈÈ磺
ÓÐÕűíΪËùÓдúÀíÉÌÿÈÕ·¢Õ¹µÄ²»Í¬Æ·ÅƵÄÊýÁ¿£¨2008Äê¼ä£©

´úÀíÉÌID  Æ·ÅÆ  ÈÕÆÚ        ÈÕ·¢Õ¹Á¿
1111      a    20080101    1
2222      a    20080101    2
1111    & ......

oracle»ù´¡ÎÊÌâ

oracle Database 10g Release 2ÖеÄrelease 2ÊÇʲôÒâ˼£¿

ÎÒ°²×°Oracle Database 10g Release 2 (10.2.0.1.0) ºÍ Oracle Datebase 10g £¨10.1.0.2.0£©Ã»Ì«´óÇø±ð°É£¿


ÒÔÉÏ2¸ö°æ±¾Çø±ðÊÇʲô£¿

¾ÍÊÇÒ»¸ö°æ±¾ºÅ°É
(10.2.0.1.0)
ÔÚ£¨10.1.0.2.0£©µÄ»ù´¡ÉϽøÐÐÁËÒ»¶¨µÄÐÞÕý
ÐÞ¸ÄÁËÄÄЩµØ·½£¬ ......
×ܼǼÊý:1827; ×ÜÒ³Êý:305; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [281] [282] [283] [284] 285 [286] [287] [288] [289] [290]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ