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 are the functions of rdbms?

948

Name the different data models that are available for database systems.

854

What is oracle block?

845

Can files be stored in a database?

890

Why do we need database management?

919

Does google have a database program?

955

Who proposed the relational model?

938

What is buffer manager?

889

What is type of end users?

772

for what purpose we use MDM(master data management)tell me plz.

4141

What is database or database management systems (dbms)? And what's the difference between file and database? Can files qualify as a database?

879

What are the examples of database?

853

Where is data stored in database?

839

What do you mean by fill factor concept with respect to indexes?

920

Explain the importance of partitioning.

939