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

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

Question Posted / venki_discussions

3 Answers
9855 Views
Oracle, Wipro, I also Faced
E-Mail Answers

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

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,

Explain the different types of languages that are available in the dbms?

0 Answers

what are primary key and foreign key ?

4 Answers Tesco,

What is a php database?

0 Answers

Describe and contrast sql and qbe.

0 Answers

Define database system.

0 Answers

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com