SQL & PL/SQL

Hi,

is it possible to bulk insert only a few columns?

example Table a (column a,colum b optional)
Table b(column a)

Now i want to bulk insert table b into table a. But only the column a.

DECLARE
Type v_table IS table b%ROWTYPE;
t_table v_table;
BEGIN
SELECT * BULK COLLECT INTO t_table
FROM table b

FORALL i IN 1..t_table.COUNT SAVE EXCEPTIONS
INSERT INTO table a
VALUES t_table(i);
END;
END;

but an error occured PL/SQL: ORA-00947 .so i changed the insert statement into
INTER INTO table a(a)... but no sucess.


is there any chance