Answer Posted / niladri chatterjee

SQL> Select * From Market;

MARKET_ID MKT_NAME AREA SALE_DT
---------------------- -------- ---- ----------
1 uss NE 25-JAN-12
1 uss NE 24-FEB-12
1 uss NE 20-JUN-11
1 uss NE 15-MAR-11
2 rus SE 21-MAR-11
2 rus NE 24-APR-11
3 ger SE 20-FEB-11
3 ger NE 22-MAR-11
3 ger NE 24-FEB-12

My Answers:-

For the Single Max Row:

Select * From (Select * From market Order By Sale_Dt Desc)
Where rownum = 1;

Followings are for each Groups:

Select *
from market a
where a.sale_dt =
(select max(b.sale_dt) from market b
where a.market_id = b.market_id);

OR

select market_id, mkt_name, max(sale_dt)
from market
group by market_id, mkt_name;

what is a Nested Loop join?

2038

---

How to drop an index?

906

---

What are the parameters that we can pass through a stored procedure?

996

---

How to pass parameters to procedures in oracle?

993

---

How to run queries on external tables?

987

---

Oracle

2318

---

What are the different types of record groups in oracle? Explain each of them

969

---

Hi Can any one tell me what are the API's used in requisition import.

1879

---

How to manage transaction isolation level?

948

---

What are a collation and state the different types of collation sensitivity?

1092

---

How to assign data of the deleted row to variables?

1012

---

In which language oracle has been developed?

1013

---

What is a connect identifier?

981

---

Explain index?

1199

---

Will you be able to store pictures in the database?explain.

928

---