使用sql:
select COLUMN_NAME from user_tab_columns where table_name='monitor';
得到的结果总是no rows selected而不加where table_name='monitor'的时候就能正常显示所有表的列名,这是什么问题?该怎么解决??多谢~!!
select COLUMN_NAME from user_tab_columns where table_name='monitor';
得到的结果总是no rows selected而不加where table_name='monitor'的时候就能正常显示所有表的列名,这是什么问题?该怎么解决??多谢~!!
------------------------------
LINE_ID
EXTRACTED_STATUS
UPDATE_DATEThere is something wrong with your matchine ...
select COLUMN_NAME from user_tab_columns where TABLE_NAME = 'FORUMS_EMAILQUEUE'COLUMN_NAME
------------------------------EMAILID
EMAILPRIORITY
EMAILBODYFORMAT
EMAILTO
EMAILCC
EMAILBCC
EMAILFROM
EMAILSUBJECT
EMAILBODY
CREATEDTIMESTAMP
SENDTIMES
你可以用select TABLE_NAME from user_tab_columns 来查找一下你的TABLE_NAME 到底包含哪些表名的