Introduction
Customer asks us to generate all the DDL source code for some database objects. So I just found the little piece of code to create DDL source.
Database Objects are,
Ø Sequence
Ø Table
Ø Index
Ø View
Ø Database Link
Ø Materialized view
Ø Function
Ø Procedure
Ø Package
Ø Package Body
Summery
This Post described Oracle had provided default package DBMS_METADATA. By using this, we can get DDL source code.
Got any queries?
Do drop a note by writing us at contact@staging.doyensys.com or use the comment section below to ask your questions.
Recent Posts