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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by entity type extension?

617


Explain the difference between primary and foreign key?

557


What are the advantages of database software?

566


What is domain in dbms?

634


For each user who needs access, the DBA creates an account in which database?

675






What is the best database to use?

539


What is second normal form?

598


Describe the types of keys?

625


define aggregate functions.

600


How is the pattern matching done in the sql?

805


Explain relational algebra?

592


Which database is faster?

544


What is a key field?

521


Explain what are service-specific middleware?

613


What do you mean by super key, primary key, foreign key and candidate key?

638