如题所述
javaè·åä¸ä¸ªoracle表çå建çsqlè¯å¥:
ç´æ¥éè¿jdbcè°ç¨ï¼SELECT DBMS_METADATA.GET_DDL('TABLE','EMP','SCOTT') FROM DUAL;å°±å¯ä»¥äºã
è¿åç»æå¦ä¸ï¼
DBMS_METADATA.GET_DDL('TABLE','EMP','SCOTT')
--------------------------------------------------------------------------------
CREATE TABLE "SCOTT"."EMP"
( "EMPNO" NUMBER(4,0),
"ENAME" VARCHAR2(10),
"JOB" VARCHAR2(9),
"MGR" NUMBER(4,0),
"HIREDATE" DATE,
"SAL" NUMBER(7,2),
"COMM" NUMBER(7,2),
"DEPTNO" NUMBER(2,0),
CONSTRAINT "PK_EMP" PRIMARY KEY ("EMPNO")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS" ENABLE,
CONSTRAINT "FK_DEPTNO" FOREIGN KEY ("DEPTNO")
REFERENCES "SCOTT"."DEPT" ("DEPTNO") ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"
ç´æ¥éè¿jdbcè°ç¨ï¼SELECT DBMS_METADATA.GET_DDL('TABLE','EMP','SCOTT') FROM DUAL;å°±å¯ä»¥äºã
è¿åç»æå¦ä¸ï¼
DBMS_METADATA.GET_DDL('TABLE','EMP','SCOTT')
--------------------------------------------------------------------------------
CREATE TABLE "SCOTT"."EMP"
( "EMPNO" NUMBER(4,0),
"ENAME" VARCHAR2(10),
"JOB" VARCHAR2(9),
"MGR" NUMBER(4,0),
"HIREDATE" DATE,
"SAL" NUMBER(7,2),
"COMM" NUMBER(7,2),
"DEPTNO" NUMBER(2,0),
CONSTRAINT "PK_EMP" PRIMARY KEY ("EMPNO")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS" ENABLE,
CONSTRAINT "FK_DEPTNO" FOREIGN KEY ("DEPTNO")
REFERENCES "SCOTT"."DEPT" ("DEPTNO") ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"
温馨提示:答案为网友推荐,仅供参考
第1个回答 推荐于2016-11-27
JDBC 连接后,执行SQL
String sql="Select Dbms_Metadata.Get_Ddl('TABLE', 'TABLE_NAME', 'OWNER')
From Dual"; //用来获取建表
sql = "Select Dbms_Metadata.Get_Ddl('INDEX', 'INDEX_NAME', 'OWNER')
From Dual;" //用来获取索引本回答被提问者和网友采纳
String sql="Select Dbms_Metadata.Get_Ddl('TABLE', 'TABLE_NAME', 'OWNER')
From Dual"; //用来获取建表
sql = "Select Dbms_Metadata.Get_Ddl('INDEX', 'INDEX_NAME', 'OWNER')
From Dual;" //用来获取索引本回答被提问者和网友采纳
第2个回答 2015-07-09
SELECT DBMS_METADATA.GET_DDL('TABLE','HELP') FROM DUAL;
第3个回答 2015-07-09
为什么不在数据库里直接看?