kalo oracle anda versi 10g:
desc dbms_metadata;
----
GET_DDL
(FUNCTION)
<return value>
CLOB
OUT
GET_DDL
OBJECT_TYPE
VARCHAR2
IN
GET_DDL
NAME
VARCHAR2
IN
GET_DDL
SCHEMA
VARCHAR2
IN        DEFAULT
GET_DDL
VERSION
VARCHAR2
IN        DEFAULT
GET_DDL
MODEL
VARCHAR2
IN        DEFAULT
GET_DDL
TRANSFORM                      VARCHAR2
----

select sys.dbms_metadata.get_ddl('TABLE','EMP','SCOTT') from dual;
salam,
J


[Non-text portions of this message have been removed]

Kirim email ke