Dbms_metadata.get_ddl table

-- 4000 characters max
SELECT dbms_metadata.get_ddl('PROCOBJ', 'job_name', 'owner') FROM DUAL;
SELECT dbms_metadata.get_ddl('PROCOBJ', 'program_name', 'owner') FROM DUAL;
SELECT dbms_metadata.get_ddl('TABLE', 'table_name', 'owner') FROM DUAL;
SELECT dbms_metadata.get_ddl('VIEW', 'view_name', 'owner') FROM DUAL;

SELECT dbms_metadata.get_ddl('PACKAGE', 'pkg_name', 'owner') FROM DUAL; 
SELECT dbms_metadata.get_ddl('PROCEDURE', 'proc_name', 'owner') FROM DUAL; 

SELECT dbms_metadata.get_ddl('INDEX', 'index_name', 'owner') FROM DUAL;
SELECT dbms_metadata.get_ddl('TYPE', 'type_name', 'owner') FROM DUAL;

Source: dba-oracle.com

Similar codes

4 votes389 views1 answer
Rename stored procedure in sql server
SQL
0 vote349 views2 answers
Mysql dump structure only
SQL
0 vote346 views1 answer
Show size of all tables postgres
SQL
16 votes341 views6 answers
Insert sql
SQL
0 vote371 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
0 vote381 views1 answer
Soql update query
SQL
0 vote371 views1 answer
Sql date between one week
SQL
9 votes332 views4 answers
Add primary key to existing table sql
SQL
0 vote370 views1 answer
On delete set default
SQL
0 vote363 views1 answer
SQL column name Oracle
SQL