select * from dba_tab_columns where owner = '&table_owner' and table_name = '&table_name';
select * from tabs where tablespace_name='USERS' ;
--表名要大写 select column_name,data_type from user_tab_columns where table_name='EMP';COLUMN_NAME DATA_TYPE ------------------------------ ------------------------------------------------- EMPNO NUMBER ENAME VARCHAR2 JOB VARCHAR2 MGR NUMBER HIREDATE DATE SAL NUMBER COMM NUMBER DEPTNO NUMBER已选择8行。
select * from all_col_comments where owner = 'USER'
where owner = '&table_owner'
and table_name = '&table_name';
--表名要大写
select column_name,data_type from user_tab_columns where table_name='EMP';COLUMN_NAME DATA_TYPE
------------------------------ -------------------------------------------------
EMPNO NUMBER
ENAME VARCHAR2
JOB VARCHAR2
MGR NUMBER
HIREDATE DATE
SAL NUMBER
COMM NUMBER
DEPTNO NUMBER已选择8行。
select * from all_col_comments where owner = 'USER'