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

What is the e-r model?

0 Answers

Explain the advantages and disadvantages of a hierarchical database?

0 Answers

What are the types of database explain each of them briefly?

0 Answers

I have one Excel file with 80,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . How can i do that?

3 Answers

What entity means?

0 Answers

Describe the Process of Feature Engineering using SQL.

1 Answers

What are database data types?

0 Answers

What is 1nf in the dbms?

0 Answers

Can A column defined as PRIMARY KEY can have NULL values ?

2 Answers

What are the main features of a database?

0 Answers

How is rdbms different from dbms?

0 Answers

Explain the term entity in dbms?

0 Answers

For more Database Management Interview Questions Click Here