2 Replies Latest reply on Dec 31, 2012 7:27 AM by CloudDB

    Table Info

    982254
      Hi,

      How to get the DML or create query of a table or a View.

      Thx
        • 1. Re: Table Info
          Manik
          Its not DML its DDL.

          dbms_metadata.get_ddl ---- CHeck in oracle documentation for more details.

          http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_metada.htm

          Cheers,
          Manik.
          • 2. Re: Table Info
            CloudDB
            As Manik      specified
            It's DDL:- Data Definition Language

            Find the command for found the DDL of specified table or view.
            set long 10000
            set pagesize 5000
            select dbms_metadata.get_ddl('TABLE','EMP') from dual;

            select dbms_metadata.get_ddl('VIEW','VWEMP') from dual;

            How to find the DDL of any Specific Database Object (e.g TABLE,VIEW,SEQUENCE etc …?)
            http://hiteshgondalia.wordpress.com/oracle/database-oam/