Answer Posted / ajit nayak

SELECT MAX( Sal ), LEVEL
FROM Emp
WHERE LEVEl = &Givelevelno
CONNECT BY PRIOR Sal > Sal
GROUP BY LEVEL;

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2274

---

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1942

---

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

953

---

What are the different types of trigger and explain its various uses and functions?

1094

---

How to create tables for odbc connection testing?

1117

---

What is define in oracle?

1060

---

Explain what are the uses of rollback segment?

1015

---

What is the best way to do multi-row insert in oracle?

1067

---

How to run queries on external tables?

1047

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2322

---

What is a trigger and what are its types in oracle?

1072

---

Explain oracle insert into command?

1112

---

How can we find out the current date and time in oracle?

1088

---

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2233

---

IS it possible to built the oracle database without setting the kernal parameters?

2348

---