Answer Posted / rajeevgeu

select rownum,salary from(select rownum r,salary from emp order by salary)where r=3;

Explain drop constraint oracle?

1072

---

What is meant by recursive hints in oracle?

1089

---

How to create a stored function in oracle?

1108

---

What is an oracle and why it is used?

1153

---

What are the advantages of oracle?

1028

---

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)

2323

---

What do you mean by cdb and pdb in oracle 12c?

1062

---

How to convert raw data type into text in oracle? Explain

993

---

How to join two tables in a single query using oracle?

997

---

What are the system predefined user roles?

1044

---

What is the difference between a hot backup and a cold backup in oracle?

1019

---

if you ctreate table identity

2375

---

How do I manually create a database in oracle?

1023

---

How to create a new table by selecting rows from another table?

1102

---

Difference between cartesian join and cross join?

1050

---