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);

what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )

2 Answers   Tech Mahindra,

---

What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?

1 Answers  

---

How can we link a sql database to an existing android app?

0 Answers  

---

how to decrement dates by 1 in mysql? : Sql dba

0 Answers  

---

Does asenumerable execute the query?

0 Answers  

---

what command is used to create a table by copying the structure of another table including constraints ?

6 Answers   CMC, eicc,

---

What is record variable?

0 Answers  

---

What is function and procedure in pl sql?

0 Answers  

---

Why is pl sql needed?

0 Answers  

---

what is difference b/w pravite procedures and public procedures?

3 Answers   Steria, Wipro, Zensar,

---

Which are the different character-manipulation functions in sql?

0 Answers  

---

What is posting?

0 Answers  

---