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-属性查询

标签：