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;
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;
That is not to create table script ,but to retrive the same from dynamic view .