Answer / rajesh

The package procedure and function are called by using
package name.function/procedure name....

Answer / madhavi

If A function returns only one value then u can call
that function from select statement like
select packagename.functionname(parameters) from dual,


But for procedure its not possible to call through select
statement u have to call through anonymous block.
declare
begin
packagename.procedurename(actual parameters);
end;
/

What is normalization ?

9 Answers   BirlaSoft, CTS, HCL,

---

if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?

5 Answers   iFlex,

---

Is pl sql different from sql?

0 Answers  

---

What is the use of sqldataadapter?

0 Answers  

---

what is Difference between Having and Where clause?

5 Answers   IBM,

---

---

I need to write a simple query,which one is better select statement or stored procedure?and why?

2 Answers   iGate,

---

Does mysql support pl sql?

0 Answers  

---

Difference between a query and strored procedure?

4 Answers   Microsoft,

---

What are triggers in sql?

0 Answers  

---

Can we use join in subquery?

0 Answers  

---

Difference between aggregate function and analytical function?

3 Answers   Metric Stream,

---

how do you know if your mysql server is alive? : Sql dba

0 Answers  

---