自动生成Java Entity类元数据

表

SELECT
a.OWNER AS TABLE_SCHEMA,
a.TABLE_NAME,
NVL (b.COMMENT$, '') AS TABLE_COMMENT
FROM
ALL_TABLES a
LEFT JOIN SYSTABLECOMMENTS b
ON a.OWNER = b.SCHNAME
AND a.TABLE_NAME = b.TVNAME
WHERE 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