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 |
What do you understand by clause in sql?
How do queries work in a database?
What is the purpose of a field in a database?
Explain ddl interpreter?
What is the difference between a catalog and a database?
Explain why an information gap exists in most organizations.
How do you maintain a database?
Explain about the case statement present in stored procedure?
What is an artificial (derived) primary key? When should it be used?
what do u mean by implementation?
From where the Transactions per rollback segment is derived ?
What is file manager?