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

0 vote109 views1 answer
Alter database name script
SQL
-1 vote126 views3 answers
PS5
SQL
0 vote127 views1 answer
Mysql exception output
SQL
0 vote123 views1 answer
Get role postgres
SQL
0 vote117 views1 answer
Sql date d'aujourd'hui
SQL
1 vote115 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
8 votes130 views10 answers
Sql
SQL
0 vote102 views1 answer
Mysql use password error
SQL
0 vote130 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
0 vote117 views1 answer
Exclude last comma separated string mysql
SQL