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,user_tab_comments b
3 where a.table_name=b.table_name;

TABLE_NAME COMMENTS
-------------------- --------------------
DEPT
EMP
BONUS
SALGRADE

SQL>

---

2Â¥µÄÕýÈ·£¡

---

¡£¡£¡£ÎÒÔÎ
¼ÈÈ»b±íÒ²ÓÐtable_nameÕâ¸ö×Ö¶Î
ΪºÎ»¹ÒªÈ¥user_tables±íÖÐÁ¬½Ó..

---

Â¥Ö÷±í²éѯ´íÁË£¬Ó¦¸ÃÊÇ£º
select table_name,comments from user_tab_comments

---

ÒýÓÃ

user_tablesÀïûÓÐcomment×Ö¶Î
Ïë¿´×¢Ê͵Ļ°
select * from user_tab_comments

ѧϰ

---

лл¸÷λÀ²