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 is the function that is used to transfer a pl/sql table log to a database table?

1022

---

which types of join is used in sql widely? : Sql dba

982

---

What is trigger in sql? Explain

997

---

what is oracle database ? : Sql dba

1030

---

Can we insert delete data in view?

951

---

How do you drop a trigger?

992

---

Is primary key clustered or nonclustered?

1021

---

What is the difference between alter trigger and drop trigger statements?

1109

---

Is oracle sql free?

988

---

How to write html code in pl sql?

1119

---

how can we repair a mysql table? : Sql dba

981

---

What are all the different types of indexes?

1148

---

what is the difference between $message and $$message? : Sql dba

998

---

What is the difference among union, minus and intersect?

1000

---

How do I make my sql query run faster?

941

---