Answer Posted / vasanth

Truncate
1.Truncate Can be DDL Command.
2.it can be rollback.
3.we cann't use Where clause.
4.truncate=delete+commit so we cann't rollback.
5.truncate delete all record from the table.
6.truncate is a DDL command and cannot be rollbackand all
memory space is released back to server.
7.speed faster.
8.do not chcek constraint.
Delete
1.Delete Can be DML Command.
2.it can be rollback.
3.we can use Where clause.
4.delete=delete-- so we can be rollback.
5.delete delete record from the table.
6.truncate is a DDL command and can be rollback and all
memory space is not released back to server.
7.speed slow.
8. chcek constraint.

which one is currently in used software cmpanies.

2155

---

What do you mean by hz_ in customer tables? : oracle accounts receivable

1222

---

What is the sql query to find the employee who has Nth maximum salary?

5335

---

Explain the use of table functions.

2490

---

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

1092

---

what is the link between suppliers and banks in ap module in oracle apps? And also query?

2472

---

as a technical developer in oracle applications which type errors feced in your experience sofar

2333

---

we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

2525

---

What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3938

---

What is Tax Categories?

2113

---

What do you mean by Oracle MEDIA RECOVERY?

1229

---

Where in the Oracle directory tree structure are audit traces placed?

2640

---

i want to know about the javaBean.what is its purpose and how it can use in Forms.

2466

---

Is there any link between pr form(purchse requisition)and po form(purchase order)

2729

---

default triggers available for reports

2219

---