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 posting?

0 Answers  

---

How many disk partitions should I have?

0 Answers  

---

What is sorting in sql?

0 Answers  

---

What is oracle sql developer?

0 Answers  

---

What will be the output for the below Query Select 'High' from dual where null = null;

12 Answers   Infosys, Satyam,

---

---

What do you mean by field in sql?

0 Answers  

---

What is sql and also describe types of sql statements?

0 Answers  

---

How many types of sql are there?

0 Answers  

---

what is a composite key ? : Sql dba

0 Answers  

---

Is sql scripting language?

0 Answers  

---

Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.

5 Answers   Thomson,

---

If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?

4 Answers  

---