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

Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)

15 Answers   Satyam,

---

If a cursor is open, how can we find in a pl/sql block?

0 Answers  

---

How to load data with sql*loader?

0 Answers  

---

If records are inserted into table without committing.How to refer to these values in a procedure?

2 Answers  

---

How do I find sql profiler?

0 Answers  

---

---

Where is all the data on the internet stored?

0 Answers  

---

What is sql partition?

0 Answers  

---

Explain what is table in a database?

0 Answers  

---

What are the benefits of pl sql?

0 Answers  

---

what are integrity rules?

0 Answers  

---

What are the 3 types of behavioral triggers?

0 Answers  

---

How to run sql commands in sql*plus?

0 Answers  

---