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

5 votes318 views2 answers
Create table
SQL
0 vote343 views1 answer
Sql server count all tables rows
SQL
0 vote374 views1 answer
Mysqli last row
SQL
3 votes363 views3 answers
Create table in microsoft sql server
SQL
2 votes305 views1 answer
Mysql admin u root p password change password
SQL
0 vote360 views1 answer
Mysql c commands
SQL
0 vote359 views1 answer
Get rows from 1 table with other table empty mysql
SQL
0 vote378 views1 answer
Sql query to find percentage of null values in a table
SQL
0 vote377 views1 answer
Sql missing values
SQL
1 vote355 views1 answer
Mysql dump specific tables
SQL