Answer Posted / hiten

select max(sal) from emp where sal not in(select max(sal)
from emp);

How to change user password in oracle?

975

---

What is an oracle?

958

---

How to export data with a field delimiter?

971

---

How do I recompile a procedure in oracle?

912

---

How to find out what oracle odbc drivers are installed?

979

---

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

1986

---

Does facebook use oracle?

981

---

what is the difference between data migration and production migration.

2276

---

What privilege is needed for a user to create views in oracle?

981

---

What is not equal to in oracle?

953

---

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.

3275

---

defination of bitmap index

2047

---

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2022

---

Which is better Oracle or MS SQL? Why?

4827

---

What is difference between sid and service name in oracle?

906

---