Answer / vidya

If you name the parameter then you can interchange
otherwise you cannot. Like in the following example the
first case is positional and you cannot interchange. In the
second one its named and you can interchange.

Regular OraDatabase.standproc(102,'RAM'); -- Positional
OraDatabase.standproc(empno=>102,ename=>'RAM'); --Named

OraDatabase.standproc(ename=>'RAM',empno=>102);

how mysql optimizes distinct? : Sql dba

0 Answers  

---

Where is pl sql used?

0 Answers  

---

write a procedure to find top second no from a list of numbers

1 Answers   ABC,

---

What are the qualities of 2nf?

0 Answers  

---

How do I add a primary key to a table?

0 Answers  

---

---

How many types of database triggers can be specified on a table ? What are they ?

2 Answers  

---

What is 19 null in sql?

0 Answers  

---

What is interval partition?

0 Answers  

---

Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin

5 Answers   Deloitte, Ness Technologies,

---

suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??

5 Answers   Keane India Ltd,

---

Difference between inline query and stored procedure?

4 Answers   Bharat, Microsoft,

---

How do you retrieve the last N records from a table?

10 Answers  

---