what is difference b/w pravite procedures and public
procedures?

Answer Posted / siva

If the procedure is with in the package it is the public
procedure,other wise it is private procedure.

Is This Answer Correct ?    18 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between rownum pseudo column and row_number() function? : Sql dba

608


What does count (*) mean?

517


How do I debug a stored procedure?

617


Define commit?

537


what are the differences between require and include, include_once and require_once? : Sql dba

518






What are the different types of functions in sql?

509


What is int identity in sql?

567


what are the advantages of using stored procedures? : Sql dba

607


What is rownum and rowid?

560


What are the different types of constraints?

556


what are the disadvantages of mysql? : Sql dba

560


How to raise user-defined exception with custom sqlerrm ?

671


Why do we create stored procedures & functions in pl/sql and how are they different?

498


How to pipe multiline string to isql?

567


what are properties of a transaction? : Sql dba

551