How to get Oracle create table statement in SQL*Plus

by

From Get table and index DDL the easy way:

set heading off;
set echo off;
Set pages 999;
set long 90000;

spool ddl_list.sql

select dbms_metadata.get_ddl('TABLE','DEPT','SCOTT') from dual;

select dbms_metadata.get_ddl('INDEX','DEPT_IDX','SCOTT') from dual;

spool off;

More Related Contents:

  1. When do I need to use a semicolon vs a slash in Oracle SQL?
  2. How do I spool to a CSV formatted file using SQLPLUS?
  3. How do I ignore ampersands in a SQL script running from SQL Plus?
  4. Escaping ampersand character in SQL string
  5. How to kill a running SELECT statement
  6. sqlplus statement from command line
  7. How to insert a string which contains an “&”
  8. LISTAGG in Oracle to return distinct values
  9. Fetch the row which has the Max value for a column
  10. Oracle SQL: Update a table with data from another table
  11. Oracle SQL – How to Retrieve highest 5 values of a column [duplicate]
  12. Concatenate and group multiple rows in Oracle [duplicate]
  13. SQL to generate a list of numbers from 1 to 100
  14. How to use BOOLEAN type in SELECT statement
  15. SQL Error: ORA-00933: SQL command not properly ended
  16. CASE vs. DECODE
  17. DATEDIFF function in Oracle [duplicate]
  18. Check if current date is between two dates Oracle SQL
  19. Unordered results in SQL
  20. Oracle Dynamic Pivoting
  21. create custom function for date difference excluding weekends and holidays in oracle sql
  22. What is it exactly a BLOB in a DBMS context
  23. Custom Order in Oracle SQL
  24. Compare Strings ignoring accents in SQL (ORACLE)
  25. Return number from Oracle Select statement after parsing date
  26. How do you interpret a query’s explain plan?
  27. How to call Oracle MD5 hash function?
  28. Oracle Convert TIMESTAMP with Timezone to DATE
  29. SQL Server equivalent of WM_CONCAT function [duplicate]
  30. Oracle: ‘= ANY()’ vs. ‘IN ()’

Leave a Comment