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

What is the difference between row level and statement level trigger?

1072

---

How do you define a foreign key?

1063

---

What is trigger in sql?

1156

---

Is natural join and inner join same?

991

---

What is package in pl sql?

1086

---

What is sql mysql pl sql oracle?

1129

---

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1265

---

Are stored procedures faster than queries?

990

---

Is sql developer case sensitive?

1048

---

What are the types of functions in sql?

1064

---

Explain aggregate functions are available there in sql?

1051

---

How can you get sql*loader to commit only at the end of the load file? : aql loader

1059

---

How do I run pl sql in sql developer?

1170

---

What is a sql statement?

1018

---

What is an implicit commit?

1103

---