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

0 vote103 views1 answer
Mysql date + 1 day
SQL
0 vote153 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote161 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
4 votes139 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
7 votes180 views3 answers
Sql server check if temp table exists
SQL
1 vote136 views1 answer
Launch sql script from docker in mysql
SQL
1 vote150 views1 answer
Mamp mysql path mac
SQL
17 votes155 views4 answers
Postgres list users
SQL
0 vote144 views2 answers
How to relationship query two different tables in MySQL
SQL
0 vote164 views1 answer
Default password for mysql_secure_installation in mac
SQL