2008-02-19 09:00:16 / Oracle入门与认证
CREATE TYPE SCORE_TYPE3 AS OBJECT(NO NUMBER,ITEM VARCHAR2(60),SCORE NUMBER)CREATETYPE SCORE_NESTED3 AS TABLE OF SCORE_TYPE3;CREATETABLE PLAYER3(GUID NUMBER,NAME VARCHAR2(20),SCORE3 SCORE_NESTED3)NESTED TABLE SCORE3 STORE AS SCORE_NESTED_TABLE3drop table PLAYER3INSERT INTO PLAYER3 (NAME,SCORE3) VALUES ('xling',SCORE_NESTED3(SCORE_TYPE3(1,'1',100)))select * from PLAYER3大家運行我的這個代碼看看 這個代碼
查看(295)
评论(2)