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
What are codd rules?
What is database schema in dbms?
What integrity rules exist in the dbms?
What is dbms with example?
What are some disadvantages of a standard language such as sql?
i have cleared the nic test...please send me the interview questions if anyone have them.... my email id is v84priya@gmail.com
What are the types of database?
Mention the different types of dbms.
How do you notify dbpak about stored procedure?
what do u mean by implementation?
Is access a database program?
What are the various types of relationships in database? Define them.
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.....
Why is data modelling important?
Are databases stored on servers?