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
What is difference between database and spreadsheet?
What is the sql 'in' clause?
Which two statements are true about a foreign key?
What are the applications of database?
How to connect Silverlight application to database?
Which parameters are optional in init.ora parameter file?
Why is database important?
How do you create a simple database?
What is progress open edge?
Define checkpoint.
1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????
Is google a database?
What is use of foreign key?
Explain 5nf?
What is the purpose of using a model?