Below statement gets the database object definition from database.
select dbms_metadata.get_ddl('OBJECT_TYPE','OBJECT_NAME','SCHEMA') from dual;
Object_type,Object_name and Schema should be in Caps.
select dbms_metadata.get_ddl('OBJECT_TYPE','OBJECT_NAME','SCHEMA') from dual;
Object_type,Object_name and Schema should be in Caps.
No comments:
Post a Comment