Answer Posted / 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);

Can sql function call stored procedure?

1021

---

Why trigger is used in sql?

970

---

When you have to use a default "rollback to" savepoint of plvlog?

1191

---

How does sql store data?

917

---

What is the difference between an inner and outer join?

1012

---

What is a table?

1015

---

Are pl sql variables case sensitive?

1046

---

How do rank () and dense_rank () differ?

1044

---

Why we use triggers in mysql?

992

---

how can we submit a form without a submit button? : Sql dba

985

---

what's the difference between a primary key and a unique key? : Sql dba

1050

---

what are all types of user defined functions? : Sql dba

1042

---

What is difference between inner join and self join?

1084

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1345

---

What are data types in pl sql?

1141

---