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 ......
Óö¼ûÁËÒ»¸öÕâÖÖÇé¿ö A ÔÚÄÚÍø B ÓÐÄÚÍøºÍÍâÍøµÄÍø¿¨ C ΪÍâÍø
Oracle Server ×°ÔÚAÀï ÏÖÔÚÖ»Äܱ»B·ÃÎÊ
ÏëÇëÎʸ÷·¸ßÊÖ ÄÜ·ñ½«B ×öÒ»¸öÀàËÆAdapter µÄ¶«Î÷
¼´ ÎÒʹÓà C ½«B ×ö³ÉÖÐת À´· ......
ÎÒÒª²éѯµ±Ç°Óû§µÄËùÓбíÒÔ¼°±í×¢Ê͵Ä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 ......
RTÎÒÓõÄÊÇOracle9iµÄÊý¾Ý¿â£¬Á¬½Ó±¾µØµÄOracleûÓÐÈκÎÎÊÌ⣬µ«ÊÇÎÒÁ¬½ÓÆäËû»úÆ÷µÄOracleµÄʱºò×ÜÊDZ¨³öûÓÐûÓмàÌýÆ÷ÕâÊÂÔõô»ØÊ£¬¼àÌýÄÇЩ¶«Î÷¶¼ÊÇÆô¶¯Á˵ġ£¡£¡£
¼àÌý¶Ë¿Ú¶ÔÉÏû£¿
ÓÃeasy connect³¢ÊÔһϣº
SQL code:
sqlplus /nolog
conn user/password@'target_host_or_ip:port_number/instance_n ......
±ÈÈ磺
ÓÐÕűíΪËùÓдúÀíÉÌÿÈÕ·¢Õ¹µÄ²»Í¬Æ·ÅƵÄÊýÁ¿£¨2008Äê¼ä£©
´úÀíÉÌID Æ·ÅÆ ÈÕÆÚ ÈÕ·¢Õ¹Á¿
1111 a 20080101 1
2222 a 20080101 2
1111 & ......
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£©µÄ»ù´¡ÉϽøÐÐÁËÒ»¶¨µÄÐÞÕý
ÐÞ¸ÄÁËÄÄЩµØ·½£¬ ......