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 the maximum number of triggers, you can apply on a single table?

0 Answers  

---

What is the basic structure of PL/SQL ?

6 Answers  

---

What is sql in oracle?

0 Answers  

---

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

---

What program will open a mdb file?

0 Answers  

---

Can we use distinct and group by together?

0 Answers  

---

What are different types of keys?

0 Answers  

---

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

0 Answers   MCN Solutions,

---

How do I debug a stored procedure?

0 Answers  

---

What is the purpose of normalization?

0 Answers  

---

Explian rowid, rownum? What are the psoducolumns we have?

0 Answers  

---

What is snowflake sql?

0 Answers  

---