Answer Posted / nithya

The delete statement will result in the table spaces or
memories would remain as the current size and table
structure remain in the database. Delete is not effective
when you use it to remove all data from a table, because it
takes up storage spaces due to unclear memories.

The truncate statement will result in clearing table spaces
or memories and the table structure remain in the database.
Therefore it free table storage spaces and use it only when
you need to remove all data from a table.

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

1029

---

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

2174

---

How would you determine what sessions are connected and what resources they are waiting for?

2078

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7578

---

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2020

---

can u give guidance abt packages of plsql

2113

---

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1733

---

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.

2448

---

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

2155

---

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

5233

---

What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

1257

---

What is supporting issues GL AP and AR?

2475

---

Explain the use of table functions.

2396

---

Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

1111

---

What is the disk migration? what is the steps involved in oracle disk migration?

1180

---