Plus more of the same for indexes and views.ĭDL was a time-consuming and tricky process. It is clear that this little script would need thousands of lines of code
||' TABLESPACE ' || rtrim(tablespace_name) ||&CRīut with the plethora of table structural design options such asĬlustering, partitioning, index organized tables, external tables and such, ||' PARALLEL (DEGREE ' || rtrim(DEGREE) || ') ' || &CR Rtrim(decode(nullable,'N','NOT NULL',null))
To_char(data_precision) || ',' || to_char(data_scale)), 'NUMBER',decode(to_char(data_precision),null,null, 'NUMBER',decode(to_char(data_precision),null,null,'('), Rtrim(decode(data_type,'DATE',null,'LONG',null,
0 kommentar(er)
