dbms_metadata.get_xml : dbms_metadata « System Packages « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Packages
  3. dbms_metadata
SQL> set long 32000
SQL> set heading off
SQL> set pagesize 32000
SQL> spool xml
SQL>
SQL> select dbms_metadata.get_xml('TABLE', 'emp', 'java2s') from dual;
SQL>
SQL> spool off
SQL> Set heading on
SQL> set pagesize 20
SQL>
SQL>








31.15.dbms_metadata
31.15.1.dbms_metadata.get_ddl( 'TABLE', 'TABLENAME' )
31.15.2.dbms_metadata.get_xml