Answer Posted / pravesh kumar

Truncate
1.Truncate Can be DDL Command.
2.it cannot 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.

3. Steps in UAT?

2472

---

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

2203

---

which one is currently in used software cmpanies.

2197

---

Give two methods you could use to determine what DDL changes have been made.

6848

---

What is the use of lockboxes? : oracle accounts receivable

1262

---

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

1206

---

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

2260

---

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2461

---

What view would you use to determine free space in a tablespace?

2287

---

what are basic modules required to implement oracle application in any oraganisation?

2256

---

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2147

---

What is Tax Categories?

2159

---

Difference between negative and positive adjustments : oracle accounts receivable

1159

---

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2334

---

8. Supporting AP, AR and GL?

2359

---