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

How do you select unique values in sql?

0 Answers  

---

Explain the structure of pl/sql in brief.

0 Answers  

---

List the different type of joins?

0 Answers  

---

How many columns should be in an index?

0 Answers  

---

What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

4 Answers  

---

What are the syntax and use of the coalesce function?

0 Answers  

---

Whis is not false in primary key?

0 Answers   Fintellix,

---

Is not null in sql?

0 Answers  

---

What is character functions?

0 Answers  

---

What is pl sql quora?

0 Answers  

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,

---

What is sql entity?

0 Answers  

---