Answer Posted / dheeraj

Delete is DML Command ,Whereas Trucate is DDL command

Delete can be Rolled Back,Truncate cannot be rolled back,

Truncate is much faster then Delete

Delete will not released the memory space ,Memories would
be same if we use delete command the structure of the
table is still there

Trncate can be free the space in the meomory

Delete , use check constraints if exits then show error

Truncate don't use check constraint

What is the difference between conversions and interfaces? : oracle accounts receivable

650

---

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

641

---

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

1769

---

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.

1871

---

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

1620

---

---

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?

1918

---

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

1767

---

Explain how to close periods in ar. : oracle accounts receivable

706

---

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

1768

---

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2051

---

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

4285

---

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

1704

---

Differentiate between transaction type and transaction source? : oracle accounts receivable

677

---

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

1842

---

can u pls share responsibilities for production how to environment in odi?and how to generate report ?

1902

---