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 union, minus and interact commands? : Sql dba

0 Answers  

---

In a package if we have 10 procedures or functions,How to know which will execute first?

1 Answers   Sollet Soft,

---

----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6

4 Answers   ICICI,

---

List the differences between plsql - function & procedures

2 Answers   TCS, Verizon,

---

What are the three forms of normalization?

0 Answers  

---

---

What is the use of time stamp in select statement?

1 Answers   TCS,

---

What is primary key sql?

0 Answers  

---

What is a sql schema used for?

0 Answers  

---

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,

---

Can we delete column in sql?

0 Answers  

---

Does postgresql run on the cloud?

0 Answers  

---

Why we use stored procedure instead of query?

0 Answers  

---