how to pass values from one table to another by using Bulk
collect?
Answers were Sorted based on User's Feedback
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 |
Answer / laxmi narayana moru
INSERT INTO T1 AS SELECT * FROM T2;
Is This Answer Correct ? | 2 Yes | 3 No |
Answer / laxmi narayana moru
insert into table1 as select * from table1;
Is This Answer Correct ? | 1 Yes | 8 No |
Define a relation schema and a relation.
what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards,
What do you mean by e-r model?
What are different types of joins in the sql?
What is database management system(dbms) and why it is used?
What is data management process?
Can we attach the same List of Values to different fields in Design time ?
Who is the founder of database?
What do you mean by fill factor concept with respect to indexes?
What is atomicity in dbms?
Mention some disadvantages of query?
What is network database?