How to insert data in nested table using procedure in pl/SQL?
how to pass parameter in nested table through procedure?
CREATE OR REPLACE TYPE "CYBER_B" AS OBJECT
( REC_ID VARCHAR2(250),
START_DATE TIMESTAMP,
END_DATE TIMESTAMP,
CREATION_DATE TIMESTAMP,
ADV_DURATION TIMESTAMP,
ADV_IMAGE BLOB,
IMG_FILENAME VARCHAR2(250),
IMG_MIMETYPE VARCHAR2(250)
);
CREATE TYPE CYBERB1 AS TABLE OF CYBER_B;
CREATE TABLE "CYBER1_TABLE"
( "AD_ID" VARCHAR2(64),
"USERNAME" VARCHAR2(250) NOT NULL ENABLE,
"SELLER_DETAIL1" "CYBERB1" ,
PRIMARY KEY ("AD_ID") ENABLE
)
NESTED TABLE "SELLER_DETAIL1" STORE AS "ADV1_DETAIL";
cyber_b is object
cyberb1 is type
cyber_table is my table
I want to create a procedure which inserts data in nested table
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…