Answer / Ankur Parashari

$ORACLE_HOME represents the directory path of the Oracle software installation for a specific version, including all its files and subdirectories. On the other hand, $ORACLE_BASE represents the top-level directory of the Oracle software installation.

How to drop an existing table in oracle?

1 Answers  

---

How can we delete duplicate rows in a table?

1 Answers  

---

I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.

4 Answers  

---

How to use "in out" parameter properly?

1 Answers  

---

What is object data modeling?

1 Answers  

---

What is oracle thin client?

1 Answers  

---

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

1 Answers  

---

How to check your oracle database 10g xe installation?

1 Answers  

---

can you call insert/update/delete in select statements. If yes how? If no what is the other way?

2 Answers  

---

what are the advantages of running a database in NO archive log mode?

1 Answers  

---

Which is better Oracle or MS SQL? Why?

3 Answers   Bally Technologies,

---

what is unique key?

14 Answers   Amazon, Cap Gemini, Infosys, Wipro,

---