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