发布网友 发布时间:2022-04-30 01:03
共2个回答
懂视网 时间:2022-04-30 05:24
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-属性查询
标签:
热心网友 时间:2022-04-30 02:32
你是什么工具,如果是sqlplus