Answer Posted / nagaraju

SELECT LEVEL,MAX(SAL)
FROM EMP
WHERE LEVEL IN(2,3)
CONNECT BY PRIOR SAL>SAL
GROUP BY LEVEL;

Why we use bulk collect in oracle?

536

---

How to convert a string to a date in oracle database?

542

---

What is a table in oracle?

543

---

What are joins, explain all types of joins?

1724

---

what happened to the global index when I truncate the data in one of the partition?

1518

---

---

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.

2886

---

Explain oracle insert into command?

630

---

Can a parameter be passed to a cursor?

600

---

Does facebook use oracle?

575

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

524

---

What is the difference between a user and a schema in oracle?

562

---

What is Segment Advisor in Oracle?

669

---

How to rename an existing table?

607

---

How to bring a tablespace offline?

543

---

How to start a specific oracle instance?

582

---