OracleÖв鿴×Ô¼º´´½¨µÄ±í - Oracle / ¸ß¼¶¼¼Êõ

Ôõôͨ¹ýÃüÁî²é¿´×Ô¼ºÒѾ­´´½¨µÄ±í£¿

---

select tname from tab;

---

SQL code:

--1.sysÓû§µÇ¼
select table_name
from dba_indexes
where table_owner = '̞';

--2.ËùÓÐÓû§
select * from tab;

---

select dbms_metadata.get_ddl('TABLE','TABLE_NAME','USER_NAME') from dual;

²ÎÊýÈ«²¿´óд¡£

ÁíÍ⣬ͨ¹ýÃüÁî²é¿´´æ´¢¹ý³ÌºÍº¯Êý:select text from all_source where name=upper('object_name');

---

2Â¥Õý½â

select * from tab;  
ÓÖѧÁËÒ»ÕУ¡

---

ѧϰ!

---

ÎÒÒ»Ö±ÓÃÕâ¸ö£º
ÏȲ鿴һϱí½á¹¹£º desc user_tables;
È»ºó²é±íÃû¾ÍÐÐÁË
select table_name from user_tables;

---

select * from tab where tabtype='TALBE';
»òÕßÊÇ
select * from user_tables;
»òÕßÊÇ
select count(*) from all_tables where owner='Êý¾Ý¿âÓû§Ãû' ;

---

select table_name from user_tables
Ò»°ãÇé¿öÏ£¬ÓÃÕâ¸ö¾Í¿ÉÒÔÁË°É£¿

---

select * from user_tables

---

select table_name from user_tables;