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

Can I join the same table twice?

1039

---

Is primary key is clustered index?

995

---

What is structural independence and why is it important?

1026

---

What is the starting oracle error number? What is meant by forward declaration in functions?

983

---

What is a behavioral trigger?

967

---

What are the types of operators available in sql?

1056

---

How much ram can sql express use?

977

---

Which are the different types of indexes in sql?

1053

---

What are sql ddl commands?

1083

---

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1156

---

how to increment dates by 1 in mysql? : Sql dba

970

---

Why do we use joins in sql?

968

---

Which are sql * plus commands?

1118

---

What are the commands used in sql?

1061

---

What is optimistic concurrency control? : Transact sql

979

---