自动生成Java Entity类元数据

表

SELECTa.OWNER AS TABLE_SCHEMA,a.TABLE_NAME,NVL (b.COMMENT$, '') AS TABLE_COMMENTFROMALL_TABLES aLEFT JOIN SYSTABLECOMMENTS bON a.OWNER = b.SCHNAMEAND a.TABLE_NAME = b.TVNAMEWHERE a.STATUS = 'VALID'

列

SELECT   a.OWNER AS TABLE_SCHEMA,  a.TABLE_NAME,  a.COLUMN_NAME,  a.DATA_TYPE AS COLUMN_TYPE,  a.DATA_LENGTH AS COLUMN_LENGTH,  DECODE(d.CONSTRAINT_TYPE, 'P', 'YES', '') AS COLUMN_KEY,  a.NULLABLE,  NVL (b.COMMENT$, '') AS COLUMN_COMMENT FROM  ALL_TAB_COLUMNS a   LEFT JOIN SYSCOLUMNCOMMENTS b     ON a.OWNER = b.SCHNAME     AND a.TABLE_NAME = b.TVNAME     AND a.COLUMN_NAME = b.COLNAME   LEFT JOIN ALL_CONS_COLUMNS c     ON b.SCHNAME = c.OWNER     AND b.TVNAME = c.TABLE_NAME     AND b.COLNAME = c.COLUMN_NAME   LEFT JOIN ALL_CONSTRAINTS d     ON c.CONSTRAINT_NAME = d.CONSTRAINT_NAME     AND c.OWNER = d.OWNER     AND c.TABLE_NAME = d.TABLE_NAME

查看表占用的空间

  SELECT TABLE_USED_SPACE('SYSDBA', 'TEST');