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

3 votes338 views2 answers
Sql end of month
SQL
0 vote334 views1 answer
Mysql subdate
SQL
25 votes343 views5 answers
Date in mysql
SQL
0 vote377 views1 answer
Oracle chain step succeeded
SQL
3 votes320 views4 answers
Mysql delete duplicate rows
SQL
26 votes271 views10 answers
Insert in to table sql
SQL
0 vote361 views1 answer
Left join vs inner join performance
SQL
0 vote313 views1 answer
Sql select column names starting with
SQL
11 votes336 views5 answers
Sql server reset identity
SQL
19 votes346 views3 answers
Grant mysql
SQL