Tips of the day

[krishnaindia2007]

You can directly create table script from SQL *PLUS using the following command

SELECT dbms_metadata.get_ddl('OBJECT TYPE','OBJECTNAME')
FROM dual;

Ex:- SELECT dbms_metadata.get_ddl('TABLE','EMP')
FROM dual;

[debasisdas]

That is not to create table script ,but to retrive the same from dynamic view .