Answer Posted / highness

you can pass the value back to the user

by using the OUT parameter;

but mostly function is used to return only one value..

its like to compute the task and to return a value;

?? but in this case why dont u opt for a procedure, since its

designed to handle this type of situations...

Does truncate require commit?

971

---

How to test for null values?

1046

---

what are the different type of normalization? : Sql dba

1027

---

Does user triggers have entry for trigger with compilation errors?

1034

---

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1008

---

what is text? : Sql dba

1069

---

Is there a 64 bit version of ssms?

959

---

What is rowid in sql?

984

---

What is where clause in sql?

1040

---

how to run 'mysql' commands from a batch file? : Sql dba

1117

---

What is the basic structure of an sql?

1098

---

How do temporal tables work?

957

---

List different type of expressions with the example.

935

---

What is pragma in pl sql?

1109

---

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

992

---