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

Define view, sequence and index in DBMS.

0 Answers   HAL,

How do you link a spreadsheet to a website?

0 Answers  

What is entity and its types?

0 Answers  

What is openedge workgroup rdbms?

0 Answers  

How does distributed database work?

0 Answers  

What are the different stages in 'data warehousing'?

0 Answers  

What is the license for clipper?

0 Answers  

i want to know real time experience on oracle dba anybody help me please mail me aniltelkar50@gmail.com

1 Answers   IBM,

How rdbms is different from dbms?

0 Answers  

Which database is best for storing large data?

0 Answers  

Does any body has ORACLE Certification latest Dumps on 1) Oracle - 10g DBA, 2) Oracle - 9i DBA, 3) Oracle - Internet Application Developer, 4) OCA, 5) OCP 8i to 10g DBA Upgrade, 6) Oracle - 10g,7) Other Oracle Certification, if any body has please send it to taruni_2k8@yahoo.com

0 Answers   Oracle,

What is advantages of progress actional?

0 Answers  

For more Database Management Interview Questions Click Here
Categories