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

Answer Posted / laxmi narayana moru

INSERT INTO T1 AS SELECT * FROM T2;

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different stages in 'data warehousing'?

554


Compare a hierarchical and network database model?

550


What do you understand by correlated subqueries in dbms?

637


Is excel a database?

590


Mention a query to add email validation to your database

584






What are the different type of relationships in the dbms?

575


What is the difference between star flake and snow flake schema?

551


What is Database Management System?

704


Explain entity, entity type, and entity set in dbms?

529


What integrity rules exist in the dbms?

585


What is the purpose of database management system?

629


What is a foreign key constraint?

670


What is snow flake schema design in database? What's the difference between star and snow flake schema?

527


i have table as source table and flat file as target i need yo perform some logic in loading the data. is it posible? and one more thing the no of fields in source is 200+ and for target is 30+ how i can map them.........

1595


What is the best free database?

591