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

If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  

---

Explain the commit statement.

0 Answers  

---

How to run sql statements through the web interface?

0 Answers  

---

Can we insert delete data in view?

0 Answers  

---

What is the difference between pl and sql?

0 Answers  

---

---

What is rollback?

0 Answers  

---

wa procedure to return the month and the no'f developers joined in each month.

4 Answers   Fidelity,

---

What is difference between % ROWTYPE and TYPE RECORD ?

2 Answers  

---

How do I write a sql query in pgadmin 4?

0 Answers  

---

What are inner outer left and right joins in sql?

0 Answers  

---

What are the ddl commands?

0 Answers  

---

What is normalization? How many normalization forms are there?

0 Answers  

---