-- 建表语句
SELECT
CONCAT(
'CREATE TABLE '
,T.TABLE_NAME,
' ('
) cre_sql
FROM
TABLES T
WHERE
T.TABLE_NAME =
'WM_TCMPAT_INFO_B'
UNION
ALL
#字段信息
SELECT
CONCAT(T.COLUMN_NAME,
' '
,
REPLACE
(
REPLACE
(
REPLACE
(
REPLACE
(T.COLUMN_TYPE,
'varchar'
,
'varchar2'
),
'datetime'
,
'date'
),
'decimal'
,
'number'
),
'text'
,