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 user and end user?

955

Which database is faster?

959

What do you understand by join?

1187

explain about the critical recovery scenario you had experienced

2315

What are the main components of a database in healthcare?

913

Explain the role of metadata for the three-layer architecture.

985

What is n tier architecture in dbms?

990

When does checkpoint occur?

930

Why do we need database normalization?

1066

Which dbms is best?

961

What is a foreign key constraint?

1080

What do you mean by extension and intension?

1097

What is normalization? What are different type of normalization?

995

Have you heard about sixth normal form?

1067

What is a Federated Query ?

1060