Oracle Database Architecture

Get the DDL script for a table/view -->

DBMS_METADATA.GET_DDL (
object_type IN VARCHAR2,
name IN VARCHAR2,
schema IN VARCHAR2 DEFAULT NULL
)
SELECT DBMS_METADATA.GET_DDL('VIEW','TEST_V','SYSTEM') FROM DUAL;

Things to Ponder:

• Work area size influences SQL Performance and can be automatically or manually managed.