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 file is read by ODBC to load drivers ?

1 Answers   Oracle,

What is sql and where is it used?

0 Answers  

What are the importance of database in banking?

0 Answers  

what the SUBSTR(SQUARE ANS ALWAYS WORK HARD,14,6) will return ?

3 Answers   Citrix, SAP Labs,

Why is foreign key used?

0 Answers  




What is compound key?

0 Answers  

What is db dialect?

0 Answers  

Describe reporting lifecycle?

0 Answers  

RDBMS file system can be defined as

0 Answers   3i Infotech,

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 2nf in the dbms?

0 Answers  

What's the difference between clustered and non-clustered indexes?

0 Answers  

For more Database Management Interview Questions Click Here
Categories