|
|
 |
Object DDLs |
 |
| GET_DDL |
Fetch DDL for objects | dbms_metadata.get_ddl(
object_type IN VARCHAR2,
name IN VARCHAR2 ,
schema IN VARCHAR2 DEFAULT NULL,
version IN VARCHAR2 DEFAULT 'COMPATIBLE',
model IN VARCHAR2 DEFAULT 'ORACLE',
transform IN VARCHAR2 DEFAULT 'DDL')
RETURN CLOB; | | USERS | Select dbms_metadata.get_ddl(Upper('user'),Upper(s.username))From all_Users s | | TABLESPACES | Select dbms_metadata.get_ddl(Upper('tablespace'),Upper(s.tablespace_name)From dba_tablespaces s | | JOBS | Select dbms_metadata.get_ddl(Upper('procobj'),Upper(s.job_name))From dba_scheduler_jobs s
where s.job_creator='HR' | | SCHEDULE | Select dbms_metadata.get_ddl(Upper('procobj'),Upper(s.schedule_name))From dba_scheduler_schedules s
where s.owner='HR' |
|
|
 |
Copyright MyCorp © 2025 |
 |
|
 |
Statistics |
 |
|
Total online: 1 Guests: 1 Users: 0 |
 |
|
