Answer / kanchan kumari

procedure is named pl/sql block which is used by
programmer to perform any task these type of block exist in
database physically.

package is also named pl/sql block which is associated
with pl/sql variable, view, sub programs.
package can't be invoked
in other word we can say that package can contain more than
one procedure, function etc.but procedure can't

Answer / rajesh venati

A Procedure is a Named Pl/Sql program. Procedures are used
for to perform a particular task. Overloading concept is not
allowed in standard alone procedures.

Then go for Packages, package is grouping the collection of
database objects like procedures, functions, type, variable,
cursors and exception etc... Here overloading concept is
valid, we can define same name for database objects with
different type of parameters or data types.....

I believe this is useful.................

Is join an inner join?

0 Answers  

---

I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,

---

Can we have two clustered index on a table?

0 Answers  

---

How you improve the performance of sql*loader? : aql loader

0 Answers  

---

write a query to find 4th max salary

7 Answers  

---

Show the cursor attributes of pl/sql.

0 Answers  

---

How to read xml file in oracle pl sql?

0 Answers  

---

create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?

2 Answers   Polaris,

---

How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?

12 Answers   IBM, TCS, UHD,

---

How to disable a trigger name update_salary?

0 Answers  

---

What are the Diff B/W Cursor and REF Cursor

3 Answers   CTS,

---

what is 'mysqlshow'? : Sql dba

0 Answers  

---