17,090
社区成员
发帖
与我相关
我的任务
分享
SQL>
SQL> create table test(id int, name varchar(10));
Table created
SQL> select dbms_metadata.get_ddl('TABLE',upper('test')) from dual;
DBMS_METADATA.GET_DDL('TABLE',
--------------------------------------------------------------------------------
CREATE TABLE "XXXX"."TEST"
( "ID" NUMBER(*,0),
"NAME" VARCHAR2(
SQL> drop table test purge;
Table dropped
SQL>