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
10945 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

Define a relation schema and a relation.

0 Answers

How to detect the server version?

0 Answers

What is correlated subquery in dbms?

0 Answers

What is the best free database?

0 Answers

How many columns are in a database table?

0 Answers

What is the default '-sort' order for a sql?

0 Answers

Can the SNAPSHOTS be refreshed automatically ?

1 Answers

What do you understand by data redundancy?

0 Answers

What does a COMMIT statement do to a CURSOR?

1 Answers Microsoft, Oracle,

What are the 4 types of database?

0 Answers

How does a database store data?

0 Answers

Tell me about view, sequence and index in DBMS.

0 Answers Honeywell, Zomato,

For more Database Management Interview Questions Click Here