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

i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.

4 Answers   TCS,

---

write sub query for eliminating duplicate rows using analytical function?

3 Answers   Metric Stream,

---

What is clustered and non-clustered indexes?

4 Answers   Microsoft,

---

what is acid property in database? : Sql dba

0 Answers  

---

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?

8 Answers   iFlex,

---

What is a null value?

0 Answers  

---

What are the types of sql commands?

0 Answers  

---

who introduced sql?

0 Answers  

---

a procedure one in two out parameters i am waiting it in a sql query can i get the output

1 Answers  

---

What are the types of optimization?

0 Answers  

---

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

0 Answers  

---

How do you clear the screen in sql?

0 Answers  

---