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

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2259

---

What is the difference between postgresql and oracle?

977

---

Please explain oracle data types with examples?

990

---

How to get last row id?

938

---

How to assign a tablespace to a users in oracle?

990

---

What is a relational database management system?

1061

---

What is the relationship among database, tablespace and data file?

926

---

What is a system tablespace?

1004

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

972

---

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2431

---

Can you drop an index associated with a unique or primary key constraint?

967

---

How to display employee records who gets more salary than the average salary in the department?

998

---

How to drop an existing table in oracle?

1012

---

What is the disadvantage of User defind function?

2238

---

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

947

---