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;
/

Is sql considered coding?

0 Answers  

---

What is the use of sqldataadapter?

0 Answers  

---

What are the types of triggers in sql?

0 Answers  

---

difference between oracle 8i and oracle 9i

8 Answers  

---

How do I send sql query results to excel?

0 Answers  

---

when is the use of update_statistics command? : Sql dba

0 Answers  

---

Explain architecture of sql server notification services?

0 Answers  

---

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

9 Answers   Zensar,

---

What are the different types of dbmss?

0 Answers  

---

What is bind reference and how can it be created?

0 Answers  

---

What are variables in pl sql?

0 Answers  

---

Can we create table in function?

0 Answers  

---