Oracle get ddl

-- 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

14 votes175 views2 answers
How to auto increment in sql
SQL
0 vote185 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote172 views1 answer
Monthly Birthday SQL Query
SQL
13 votes191 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
1 vote180 views2 answers
Datetrunc hour snowflake
SQL
0 vote144 views1 answer
Expose db in virtualbox
SQL
2 votes224 views1 answer
Insert from table tsql
SQL
0 vote175 views1 answer
Char vs varchar2 in sql
SQL
9 votes173 views2 answers
Cmd to rename a collumn name in sql
SQL
1 vote181 views1 answer
DATE_SUB postgres
SQL