//取得數(shù)據(jù)表相應信息的SQL語句
select t.TABLE_NAME  as 表名,
       t.COLUMN_NAME as 列表,
       t.DATA_TYPE   as 列數(shù)據(jù)類型,
       t.DATA_LENGTH as 列數(shù)據(jù)長度
  from user_tab_columns t
 where t.TABLE_NAME = :tableName

 
  select s.table_name as 表名,
         s.comments as 表注釋
    from user_tab_comments s
   where s.table_name = :tableName



select y.table_name  as 表名,
       y.column_name as 字段名,
       y.comments    as 字段注釋
  from user_col_comments y
 where y.table_name = :tableName