Answer / xxx

select ename, salary from
(Select ename, salary, rownum
FROM emp where rownum<=3
Order by salary )
where rownum = 1
;

wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010

6 Answers   Accenture,

---

What is the difference between function, procedure and package in pl/sql?

0 Answers  

---

Can we use out parameter in function?

4 Answers   Infosys,

---

Are null values same as that of zero or a blank space?

0 Answers  

---

Explain what is rdbms?

0 Answers  

---

---

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

---

What is null in pl/sql?

0 Answers  

---

Why are cursors used?

0 Answers  

---

What is procedure and function in sql?

0 Answers  

---

Is sql pronounced sequel or sql?

0 Answers  

---

Explain what is sql*plus?

0 Answers  

---

there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?

12 Answers   Oracle,

---