17,377
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
penitent 2003-01-20
- 打赏
- 举报
user_tab_columns
Lastdrop 2003-01-20
- 打赏
- 举报
从数据字典表user_tab_columns或all_tab_columns中查询。
SELECT column_name FROM user_tab_columns WHERE table_name='查询表名';
SELECT column_name FROM user_tab_columns WHERE table_name='查询表名';
luyuen 2003-01-20
- 打赏
- 举报
desc col
select tname,cname from col where tname='xxxx'
select tname,cname from col where tname='xxxx'
beckhambobo 2003-01-20
- 打赏
- 举报
SQL> select column_name from all_col_comments where table_name='INFO';
COLUMN_NAME
------------------------------
EMPLOYEENO
EMPLOYEEPD
EMPLOYEE
COLUMN_NAME
------------------------------
EMPLOYEENO
EMPLOYEEPD
EMPLOYEE
