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

material view and view disadvantages?

1073

---

How to use "out" parameter properly?

1082

---

How to rename an existing table?

1129

---

How would you best determine why your MVIEW couldnt FAST REFRESH?

1889

---

Explain the truncate in oracle?

967

---

Does facebook use oracle?

1031

---

What is an Oracle index?

1655

---

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1999

---

How to return top 5 rows in oracle?

1062

---

Why use resource manager in Oracle?

1104

---

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2209

---

What is recovery manager in Oracle?

1056

---

What is redo log?

1064

---

How to invoke the original export import utilities?

1064

---

What are privileges and grants?

1067

---