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 |
Explain meant by 3-tier architecture?
What do you understand by cursor? Mention the different types of cursor?
What is database users in dbms?
What do you mean by entity type?
Why is databases important in healthcare?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name, price 101, LED Lights,200 102, 20 watt CFL Lights, 145 103, 30 watt CFL lights,155 Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence flat file product list has two column pro_name, price 20 watt tube light ,45 30 watt tube light ,60
What is hot backup and how it can be taken ?
How can I create database in excel?
What is the best free database?
Explain snapshot replication.
I am using Oracle 10g and want to access the default tables of 9i? how? Any script and how to use it please mail me @ rashi.sandhu@gmail.com........
What are notification services?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)