Bulk collect into 2 different PlSql table. The first with all data, the second whit a selection.

Hallo again,

I have a bulk select into 2 different plsql table. The first have to hold all the data, the second only "good"data.

How can I do that?

Let's have a look to test script:

CREATE TABLE ORATEST_ORG_SOURCE

(

   THE_OFF_ID   NUMBER (20),

   INPUT_DATE   DATE,

   ORG_NUM      VARCHAR2 (12 CHAR),

   EMAIL        VARCHAR2 (160 CHAR)

);

INSERT INTO ODB.ORATEST_ORG_SOURCE (THE_OFF_ID,INPUT_DATE,ORG_NUM,EMAIL)

     VALUES (1,TO_DATE ('12/13/2011', 'MM/DD/YYYY'),'123456789012','sandro');

INSERT INTO ODB.ORATEST_ORG_SOURCE (THE_OFF_ID,INPUT_DATE,ORG_NUM,EMAIL)      VALUES (2,TO_DATE ('12/13/2011', 'MM/DD/YYYY'),'12345678901a','sandro@casa.com');