Tuesday, 8 September 2020

How to generate DDL in Oracle Database

SYNTAX:

select dbms_metadata.get_ddl('TABLE','<TABLE_NAME>','<SCHEMA_NAME>') from dual;

COMMAND:

select dbms_metadata.get_ddl('TABLE','EMPLOYEE','HR') from dual;


No comments:

Post a Comment

OS Watcher Installation in RAC

 Step:1 Download and untar the oswbb812.tar under the grid user in RAC on the both nodes. Follow the OS Watcher User's Guide (Doc ID 153...