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

Can we create index on primary key?

0 Answers  

---

what is explain plan?, given an example...

3 Answers   Polaris,

---

What are the cursor attributes used in PL/SQL ?

4 Answers  

---

Is ms sql traffic encrypted?

0 Answers  

---

How does join work in sql?

0 Answers  

---

What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

6 Answers   Cap Gemini, TCS,

---

What is the usage of nvl function?

0 Answers  

---

what is called after appearing where clause

3 Answers  

---

What does the file extension accdb stand for?

0 Answers  

---

How to call a javascript function from pl sql?

0 Answers  

---

Can i use Commit inside the Trigger? Suppose i use commit what will be happy (it's complied /executed/work)

6 Answers  

---

Talk about views

10 Answers   Polaris,

---