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

Does sql*plus also have a pl/sql engine?

0 Answers  

---

Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F

6 Answers   IBM,

---

What do you understand by pl/sql packages?

0 Answers  

---

How to set up sql*plus output format in oracle?

0 Answers  

---

how instead of triger is helpful for mutating tables errors handlling ?

2 Answers   Oracle,

---

How is a process of pl/sql compiled?

0 Answers  

---

How to use sql statements in pl/sql?

0 Answers  

---

How to create your own reports in sql developer?

0 Answers  

---

How do you modify a table in sql?

0 Answers  

---

What is where clause in sql?

0 Answers  

---

Can we use distinct and group by together?

0 Answers  

---

How do I view a sql database?

0 Answers  

---