what is the difference difference between procedure and
packages

Answer Posted / 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

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

641


What does pl sql stand for?

634


What are records give examples?

531


What is the non-clustered index in sql?

563


What are all different types of collation sensitivity?

509






What are the key differences between SQL and PL SQL?

610


Mention what does the hierarchical profiler does?

540


What is the difference between a primary key and a clustered index?

499


What does over partition by mean in sql?

504


what are integrity rules?

548


What is execution plan in sql?

523


What is data type in database?

520


What is the purpose of the partition table?

525


What is a delimiter in sas?

519


what is the difference between cluster and non cluster index? : Sql dba

530