SELECT fn1,fn2,fn3 BULK COLLECT INTO t3 FROM tname; FORALL i IN 1 .. t3.

how to pass values from one table to another by using Bulk
collect?

Question Posted / lak

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is sorting in dbms?

967

Explain about the case statement present in stored procedure?

899

Who has the largest database?

987

Is sql is a dbms?

917

What is different keys in dbms?

947

Define cursor.

1040

What's the best database software for mac?

941

Why is normalisation used?

928

What are the four objects in a database?

1068

What do you mean by extension and intension?

1059

What is db flush?

906

What is sql in database management system?

952

What is tuple in dbms?

883

What is third normal form?

922

How do you use a database worksheet?

947