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.

Karkuvelraja T

Doyensys

A technology service company that provides innovative solutions around the oracle platform With Laser focus on customer delight as the primary success parameter.