Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    370

    Question Unanswered: How to find the DDL of a table or view?

    Hi all,
    Is there any dictionary view that I can find the DDL of other tables or views there? I mean something like user_source but as you know it includes only DDL of procedures,functions,triggers,packages and types.
    -Thanks in advance

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    If you are using Oracle 9i or above, see the dbms_metadata.get_ddl package
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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