how to pass values from one table to another by using Bulk
collect?

Answers were Sorted based on User's Feedback



how to pass values from one table to another by using Bulk collect?..

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

how to pass values from one table to another by using Bulk collect?..

Answer / laxmi narayana moru

INSERT INTO T1 AS SELECT * FROM T2;

Is This Answer Correct ?    2 Yes 3 No

how to pass values from one table to another by using Bulk collect?..

Answer / laxmi narayana moru

insert into table1 as select * from table1;

Is This Answer Correct ?    1 Yes 8 No

Post New Answer

More Database Management Interview Questions

Explain snapshot replication.

0 Answers  


Explain ddl interpreter?

0 Answers  


Is it possible to break netlibs encryption?

0 Answers  


How to activate all indexes in firebird?

0 Answers  


What are the main features of a database?

0 Answers  


Define scalar functions.

0 Answers  


Where the Databases overall structure is maintained ?

1 Answers  


What is Two-Phase Commit ?

3 Answers  


What are the importance of partitioning in dbms?

0 Answers  


Explain the Importance of Data Normalization.

1 Answers  


Explain the term generalization.

0 Answers  


Which database is best for storing images?

0 Answers  


Categories