how to pass values from one table to another by using Bulk
collect?
Answers were Sorted based on User's Feedback
Answer / lak
SELECT fn1,fn2,fn3 BULK COLLECT INTO t3 FROM tname;
FORALL i IN 1 .. t3.COUNT
INSERT INTO tname1 VALUES T3(i);
Is This Answer Correct ? | 10 Yes | 2 No |
Answer / laxmi narayana moru
INSERT INTO T1 AS SELECT * FROM T2;
Is This Answer Correct ? | 2 Yes | 3 No |
Answer / laxmi narayana moru
insert into table1 as select * from table1;
Is This Answer Correct ? | 1 Yes | 8 No |
What is the difference between a LIST BOX and a COMBO BOX ?
How do I create a database in open office?
Why does reading require write privileges on database file?
What do you understand by the view and mention the steps to create, update and drop a view?
What is tuple and attribute?
If CPU is very slow What can u do to speed up?
Is filemaker pro a relational database?
What is the Structural difference between bitmap and b-tree index ?
Which is the most used database?
What is instance in dbms?
What do you mean by entity type?
What is database management used for?