Generate DDL source code using Oracle SQL

Objective:
To
generate DDL source code using Oracle SQL.
Scenario:
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

Solution:

Oracle has provided default package DBMS_METADATA. By using this we can get
DDL source code.



By
Karkuvelraja T
  • January 2, 2017 | 19 views