Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

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 database connection pool size?

0 Answers  


Where is database data stored?

0 Answers  


How index hunting contributes in improving the query performance?

0 Answers  


What is pdo in database?

0 Answers  


Which database is faster?

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 do I take a backup of Stored Procedure in Oracle?

3 Answers  


1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

0 Answers  


Why do we study dbms?

0 Answers  


How to unzip a file in ssis?

0 Answers  


What is foreign key in dbms?

0 Answers  


What is distributed queries?

0 Answers  






Categories