Answer Posted / ankit

An insert all statement allows you to insert data into
multiple table with a single statement. For example:

INSERT ALL
INTO TABLE1(COLUMN1, COLUMN 2) VALUES('A','B')
INTO TABLE2(COLUMN 3,COLUMN4) VALUES ('1','2')
INTO TABLE3(COLUMN5,COLUMN6) VALUES ('2','A')
FROM DUAL

How to store only time; not date and time?

1065

---

how do u setup a replication site?

2028

---

What is a nested table?

1109

---

Explain the difference between sap and oracle?

1081

---

What do you understand by database schema and what does it hold?

1296

---

What is a subquery in oracle?

1163

---

What is a trigger and what are its types?

1320

---

Difference between oracle's plus (+) notation and ansi join notation?

1160

---

What is the use of file param in imp command?

1212

---

How to retrieve data from an explicit cursor?

1105

---

How to call a stored function in oracle?

1061

---

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2285

---

How to write a query with a right outer join in oracle?

1218

---

What are the various constraints used in oracle?

1093

---

What exactly do quotation marks around the table name do?

1016

---