Interested to Buy Any Domain ? << Click Here >> for more details...
how to pass values from one table to another by using Bulk
collect?
- 3 Answers
- 10825 Views
- Oracle, Wipro, I also Faced
- E-Mail Answers
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 is 1nf in database?
What are the importance of database in banking?
What are the steps in creating a database?
dear all,Greetings of the day.. i have a small query plz rply if u knw.. i have done MBA Hr and B.sc microbiology. i am very much interested in it industry,so i am planing to go with oracle HRMS module,can it be work out??
What is a candidate key in a database?
What is the meaning of flat file database?
How do I create a database in open office?
Why indexing is used in database?
What is data sparsity and how it effect on aggregation?
Can files be stored in a database?
Enlist some commands of dml?
How to find the size of database?
In which format data is stored in database?
State three differences between Dbms and Rdbms?
How to activate all indexes in firebird?
