SELECT
'private'||
(CASE WHEN USER_TAB_COLS.DATA_TYPE='VARCHAR2' THEN ' String '
WHEN (USER_TAB_COLS.DATA_TYPE='CHAR' AND USER_TAB_COLS.DATA_LENGTH=1) THEN ' UFBoolean '
WHEN (USER_TAB_COLS.DATA_TYPE='CHAR' AND USER_TAB_COLS.DATA_LENGTH=10) THEN ' UFDate '
WHEN (USER_TAB_COLS.DATA_TYPE='CHAR' AND USER_TAB_COLS.DATA_LENGTH=19) THEN ' String '
WHEN (USER_TAB_COLS.DATA_TYPE='CHAR' AND USER_TAB_COLS.DATA_LENGTH=20) THEN ' String '
WHEN (USER_TAB_COLS.DATA_TYPE='CHAR' AND USER_TAB_COLS.DATA_LENGTH=4) THEN ' String '
WHEN (USER_TAB_COLS.DATA_TYPE='NUMBER' AND USER_TAB_COLS.DATA_SCALE=0) THEN ' Integer '
ELSE ' UFDouble '
END
)||lower(USER_TAB_COLS.COLUMN_NAME)||'; // '||user_col_comments.comments AS filed,
USER_TAB_COLS.COLUMN_NAME as 列名 ,
USER_TAB_COLS.DATA_TYPE as 数据类型,
USER_TAB_COLS.DATA_LENGTH as 长度,
USER_TAB_COLS.DATA_SCALE as 精度,
user_col_comments.comments as 备注
FROM USER_TAB_COLS inner join user_col_comments on
user_col_comments.TABLE_NAME = USER_TAB_COLS.TABLE_NAME
and user_col_comments.COLUMN_NAME=USER_TAB_COLS.COLUMN_NAME
and lower(USER_TAB_COLS.TABLE_NAME) = 'TableName'
ORDER BY USER_TAB_COLS.COLUMN_ID;
SQL语句自动生成java代码(oracle)
最新推荐文章于 2024-06-07 18:09:50 发布