bulk collection

Get new comments by email
You can cancel email alerts at anytime.
Comments (1)

Eddy in Central District, Hong Kong

50 months ago

does anyone know how to solve the situation like this:
i have a table contain code
i would like to extract code for particular date
and then i try to use pl/sql to verify that another table input code is valid.
...procedure...
...is...
TYPE CODE_TYPE IS TABLE OF VARCHAR2(1);
CODE_LIST CODE_TYPE;
...begin...
SELECT DISTINCT CODE BULK COLLECT INTO CODE_LIST FROM CODE_TABLE WHERE AS_OF_DATE = V_DATE;
.....
INSERT INTO ANOTHER_TABLE VALUES( A_DATE, A_CODE) SELECT A_DATE, A_CODE FROM TABLE_A;

how can i verify A_CODE in TABLE_A when insert into ANOTHER_TABLE?

- Was this comment helpful? Yes / No Reply - Report abuse

» Sign in or create an account to comment on this topic.