Answer Posted / ark chowdary

DELETE: IT IS A DML COMMAND(DATA MANIPULATION LANGUAGE) .
IT DELETES DATA MEANS (DELETES ALL RECORDS) IN TABLE.
BUT STRUCTURE WILL BE THERE.
AND
DATA DELETES TEMPERORLY.
THEN USE ROLLBACK WE CAN GET THE DATA.

TRUNCATE: IT IS A DDL COMMAND (DATA DEFNITION LANGUAGE).
TRUNCATE ALL RECORDS IN A TABLE.
BUT STRUCTURE WILL BE THERE.
BUT DATA GOES PERMINANTLY.
WE CANT USE ROLLBACK HERE.
IT SHOLUD NOT WORK. WHY BCZ DATA TRUNCATES
PERMENANTLY.

Explain the use of table functions.

2573

---

What is auto invoicing? Explain : oracle accounts receivable

1165

---

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2561

---

Difference between transaction type and transaction sources. : oracle accounts receivable

1067

---

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?

2454

---

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

2287

---

what are the tools used for oracle 10g in real time.

2491

---

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

1266

---

Could you please let me know the interfaces in OM / FA??

2337

---

What is Tax Categories?

2159

---

can we use lexical perameter in oracle plsql if yes how

2371

---

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

2565

---

HOW TO SPOT AHIERARCHY?

2342

---

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

1302

---

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

1139

---