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 are codd rules?

536


What is database schema in dbms?

641


What integrity rules exist in the dbms?

516


What is dbms with example?

507


What are some disadvantages of a standard language such as sql?

483






i have cleared the nic test...please send me the interview questions if anyone have them.... my email id is v84priya@gmail.com

1423


What are the types of database?

474


Mention the different types of dbms.

496


How do you notify dbpak about stored procedure?

477


what do u mean by implementation?

1596


Is access a database program?

487


What are the various types of relationships in database? Define them.

472


What types of questions are asked in NIC(Natinal Informatics Centre)'s interview?If any one has any information about this,I would be very thankful to him/her.....

1431


Why is data modelling important?

463


Are databases stored on servers?

542