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 do you mean by entity type extension?
Explain the difference between primary and foreign key?
What are the advantages of database software?
What is domain in dbms?
For each user who needs access, the DBA creates an account in which database?
What is the best database to use?
What is second normal form?
Describe the types of keys?
define aggregate functions.
How is the pattern matching done in the sql?
Explain relational algebra?
Which database is faster?
What is a key field?
Explain what are service-specific middleware?
What do you mean by super key, primary key, foreign key and candidate key?