Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Insert data into varray
I've also tried something like this. Now Oracle says
"Error at line 1:
ORA-00913: Too many values"
INSERT INTO TABLE (SELECT t.phone_nos FROM tab_customers t WHERE t.id = 1) VALUES ('12ABC','23CDE','34EFG');
:(.
-- regardsReceived on Thu Apr 28 2005 - 17:18:44 CDT
![]() |
![]() |