/
-----Open file to dump the output of procedure
spool table_struct_data.txt
/
set serveroutput on
/
declare
l_data varchar2(10000);
l_clob clob;
begin
----------select the DDL script of table using GET_DDL Oracle Library
select DBMS_METADATA.GET_DDL('TABLE',
l_clob from DUAL;
l_data := dbms_lob.substr( l_clob, 4245, 1 );
dbms_output.put_line( l_data);
end;
/
spool off
open the file table_struct_data.txt . It will contain the create script of table MASTER_TAB
No comments:
Post a Comment