How to get create table script of existing in oracle 10g using Query

Question

I want create same table in other schema, for which i want get create table script of existing in oracle 10g using Query

Please tell me how to get it..

Answer 1

If you really want a SQL statement, you can use the dbms_metadata package

select dbms_metadata.get_ddl( 'TABLE', 'EMP', 'SCOTT' )
from dual;