这个么? http://www.weste.net/html/200310/20031016QBI223532.html278. MAKE_REF(TABLE,KEY,KEY...) 通過把給定的鍵作為主鍵來創建給定視圖對象中一行的引用. CREATE TYPE T1 AS OBJECT(A NUMBER,B NUMBER); CREATE TABLE TB1(C1 NUMBER,C2 NUMBER,PRIMARY KEY(C1,C2)); CREATE VIEW V1 OF T1 WITH OBJECT OID(A,B) AS SELECT * FROM TB1; SELECT MAKE_REF(V1,1,3) FROM PUBS;
http://www.weste.net/html/200310/20031016QBI223532.html278. MAKE_REF(TABLE,KEY,KEY...)
通過把給定的鍵作為主鍵來創建給定視圖對象中一行的引用.
CREATE TYPE T1 AS OBJECT(A NUMBER,B NUMBER);
CREATE TABLE TB1(C1 NUMBER,C2 NUMBER,PRIMARY KEY(C1,C2));
CREATE VIEW V1 OF T1 WITH OBJECT OID(A,B) AS SELECT * FROM TB1;
SELECT MAKE_REF(V1,1,3) FROM PUBS;