Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> SQL Question on convert the table structure into DML
All,
I have a problem on the following SQL. the output of the structure can not connect as a complete SQL. So Anyone can hel me?
select 0 sort2, 'create table '|| table_name || '('from user_tables
' ' || rpad(c1.column_name,30,' ') || rpad(decode((rtrim(c1.data_type) || '(' || decode(c1.data_type,'NUMBER',c1.data_precision,c1.data_length)
||
decode(c1.data_scale, null,null, 0,null, ',' || c1.data_scale) || ')'),'DATE(7)','DATE','NUMBER()','NUMBER', (rtrim(c1.data_type) || '(' || decode(c1.data_type,'NUMBER',c1.data_precision,c1.data_length)
||
decode(c1.data_scale,null,null,0,null,',' || c1.data_scale) || ')')),15,' ') || decode(c1.nullable,'NOT NULL','NOT NULL','N','NOT NULL',' ')
||
','
' ' || rpad(c1.column_name,30,' ') || rpad(decode((rtrim(c1.data_type) || '(' || decode(c1.data_type,'NUMBER',c1.data_precision,c1.data_length)
||
decode(c1.data_scale, null,null, 0,null, ',' || c1.data_scale) || ')'),'DATE(7)','DATE','NUMBER()','NUMBER', (rtrim(c1.data_type) || '(' || decode(c1.data_type,'NUMBER',c1.data_precision,c1.data_length)
||
decode(c1.data_scale,null,null,0,null,',' || c1.data_scale) || ')')),15,' ') || decode(c1.nullable,'NOT NULL','NOT NULL','N','NOT NULL',' ')
||
')'
Regards,
Wilson
Received on Sun Apr 23 2000 - 00:00:00 CDT