Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2008
    Posts
    464

    Unanswered: SQL used to create a table...9i

    Hi

    Is there a way to get the exact SQL used to create a table? (reverse engg).

    Regards
    Shajju

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Research use of DBMS_METATADA.GET_DDL.

  3. #3
    Join Date
    Aug 2008
    Posts
    464
    Will do.

    Many thanks.

  4. #4
    Join Date
    Jan 2012
    Posts
    3

    How to exact SQL used to create a table in oracle (reverse Engineering)

    In Oracle9i we have the exciting new dbms_metadata utility to display DDL directly from the data dictionary. Using this powerful utility, we can punch individual objects or an entire schema.

    You simply execute dbms_metadata. get_ddl.

    To know how to execute the check out at Salman's Blog: How to exact SQL used to create a table in oracle (reverse Engineering)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •