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.................

what is a tablespace? : Sql dba

0 Answers  

---

Is natural join and inner join same?

0 Answers  

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---

What is dml with example?

0 Answers  

---

How global cursor can be declare with dynamic trigger ?

0 Answers  

---

What's the difference between a primary key and a clustered index?

0 Answers  

---

How do I run sql?

0 Answers  

---

How to copy a table in another table with datas?

9 Answers  

---

What are the data types allowed in a table?

3 Answers  

---

Is sql scripting language?

0 Answers  

---

Does sql support programming?

0 Answers  

---

In a distributed database system, can we execute two queries simultaneously?

0 Answers  

---