SQL Server 生成oracle建表语句

declare @TABLESPACE nvarchar(100)= 'oracle tablespace'
declare @SCHEMA		nvarchar(100)= 'oracle schema'
declare @PRE		nvarchar(100)= 'table prefix'
declare @role		nvarchar(100)= 'grant role name'
declare @TABLENAME	nvarchar(100)= 'sql server table_name'

SELECT  case when a.colid=1 then 'create table '+@SCHEMA+'.'+ @PRE + D.name + '(
' else '' end
+' ' + A.name + ' '+ 
	case when len(a.name) <= 3 then '						'
		when len(a.name) between 4 and  5 then 	'						' 
		when len(a.name) between 6 and  9 then 	'					' 
		when len(a.name) between 10 and 13 then  '				' 
		when len(a.name) between 14 and 16