Sign Up Login


  1. Categories >> Software >> Databases >> Database Management
  2. Suggest New Category

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

Question Posted / venki_discussions

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

What is Data Redundancy and Consistency ?

0 Answers   MCN Solutions,

What are the objectives of rdbms?

0 Answers  

What is the difference between star flake and snow flake schema?

0 Answers  

Define dbms.

0 Answers  

Differentiate between nested loop, hash loop and merge join.

0 Answers  




Define view, sequence and index in DBMS.

0 Answers   HAL,

what is the use of SYSTEM.EFFECTIVE.DATE varaible ?

1 Answers  

Mention the different types of cursor?

0 Answers  

What is normalization and why it is used?

0 Answers  

What are the disadvantages of a database?

0 Answers  

Why do we need to use a database?

0 Answers  

What do you understand by index hunting?

0 Answers  

For more Database Management Interview Questions Click Here
Categories