Answer Posted / vipin kumar (m.c.a)

For calling both have the different method--
To call function

variablename:=functionname(arguments);

To call procedure

procedurename(argumentlist);

What is oracle sql called?

970

---

How can we store rows in PL/SQL using array?

1263

---

Explain some predefined exceptions.

1087

---

What are the indexing methods?

1095

---

How does a self join work?

1223

---

What is sql character function?

1145

---

How do you write a subquery?

1063

---

what is the functionality of the function htmlentities? : Sql dba

1001

---

Which operator is used in query for pattern matching?

1125

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2133

---

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

2138

---

what is a table in a database ? : Sql dba

1086

---

How do temporal tables work?

1016

---

Why stored procedure is better than query?

994

---

how can we know the count/number of elements of an array? : Sql dba

1104

---