1. sql to oracle
功能:将mysql的整库建表语句,刷成oracle的建表语句,符合oracle的语法
SELECT table_schema
,table_name
,(
CASE
WHEN ORDINAL_POSITION = mincol
AND ORDINAL_POSITION < maxcol
THEN CONCAT (
"create table if not exists "
,table_schema
,"."
,table_name
,"("
,column_name
," "
,COLUMN_TYPE
,","
)
WHEN ORDINAL_POSITION = mincol
AND ORDINAL_POSITION = maxcol
THEN CONCAT (
"create table if not exists "
,table_schema
,"."
,table_name
,"("
,column_name
," "
,COLUMN_TY