Oracle-屬性查詢

標籤：

1. 查詢表的部分欄位屬性

select t.*, c.comments  from user_tab_columns t, user_col_comments c where t.table_name = c.table_name   and t.column_name = c.column_name   and t.table_name = ‘EL_LESSON‘   and t.COLUMN_NAME in (‘LESSONID‘,                         ‘LESSONNAME‘,                         ‘LESSONGOAL‘,                         ‘NOTE‘,                         ‘TEACHERNAME‘,                         ‘TEACHERID‘,                         ‘CLASSIDNAME‘,                         ‘CLASSID‘,                         ‘CRTIME‘,                         ‘STATUS‘,                         ‘OPERTIME‘)

 

 

Oracle-屬性查詢