Answer Posted / re

hey kumaran ...

its not like out paramaters cannot used.........

but its not preferred ...

its just simple ... just move basics why/for what a function
, procedures is used..

also with conditional if stmts... result is that a single
value is returned
re

What are %type and %rowtype for?

1100

---

what are the differences between char and varchar? : Sql dba

1111

---

what is the difference between a having clause and a where clause? : Sql dba

1154

---

What are the different types of a subquery?

1099

---

What is microsoft t sql?

981

---

How do I run a sql script?

1221

---

How do I run a sql trace?

997

---

What does partition by mean in sql?

1022

---

What is application trigger?

1050

---

Is primary key an index?

1032

---

What are the subsets of sql?

1192

---

What are operators available in sql?

1093

---

Is natural join and inner join same?

988

---

What is the difference between functions, procedures, and packages in pl/sql?

1087

---

what is the difference between inner and outer join? Explain with example. : Sql dba

1058

---