DBA Objects

Description

Categories
Enginatics
Repository
GitHub
All database objects.

Show DDL returns each object's DDL or source code. DDL longer than 32,000 characters is split over several rows, numbered in column DDL Part, as an Excel cell holds at most 32,767 characters.

SQL 53 lines

Parameters 5

ParameterTypeList of values SQL
Object Name likeLOV
lower(do.object_name) like lower(:object_name)
OwnerLOV
do.owner=:owner
Object TypeLOV
do.object_type=:object_type
StatusLOV
do.status=:status
Show DDLLOV
,rowgen.column_value ddl_part,substr(x.ddl,(rowgen.column_value-1)*32000+1,32000) ddl