how to pass values from one table to another by using Bulk
collect?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / laxmi narayana moru
INSERT INTO T1 AS SELECT * FROM T2;
Is This Answer Correct ? | 2 Yes | 3 No |
Answer / laxmi narayana moru
insert into table1 as select * from table1;
Is This Answer Correct ? | 1 Yes | 8 No |
Explain snapshot replication.
Explain ddl interpreter?
Is it possible to break netlibs encryption?
How to activate all indexes in firebird?
What are the main features of a database?
Define scalar functions.
Where the Databases overall structure is maintained ?
What is Two-Phase Commit ?
What are the importance of partitioning in dbms?
Explain the Importance of Data Normalization.
Explain the term generalization.
Which database is best for storing images?