Answer Posted / pavan_1981

truncate is ddl command.its faster than delete as it doesnt
have go through the rollbacks etc.truncate being a ddl is
auto commit.we can only truncate the whole table(cant use
where clause).once table is truncated we cant rollback the
changes.when a table is truncated the memory occupied is
released.that id the water mark is adjusted.

delete is a dml command and can be rolled back.is slower
than truncate as it is dml has to go through rollback
segments etc.we can use where clause with delete.when a
table is deleted memory occupied is not released ans also
the water mark is not adjusted.

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

2127

---

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

2135

---

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

2216

---

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

2208

---

What is the mandatory setup in cyclecount ?

2753

---

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

1281

---

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

2411

---

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

2525

---

What is the use of lockboxes? Steps for lock box : oracle accounts receivable

1393

---

Why more redos are generated when the oracle database is in begin backup mode?

1120

---

What is an Oracle database Partial Backup?

1161

---

hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

2231

---

How do you create a credit note against an invoice? : oracle accounts receivable

1085

---

what are the API of GL,PO,AP

2269

---

1. What is PO rate variance gain and loss?

2920

---