Tell me what a package consists of.

Answer Posted / nashiinformaticssolutions

A PL/SQL package contains related procedures, functions, variables, and other PL/SQL constructs. It consists of two main parts:
• Package Specification: This defines the public interface of the package, including procedures, functions, and global variables that other programs can access.
• Package Body: This contains the actual implementation of the functions and procedures defined in the specification.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you view the errors encountered in a trigger?

735


Why is sql better than hql?

688


Mention what pl/sql package consists of?

724


what is bcp? When does it used? : Sql dba

706


What is user defined functions?

746






Can a varchar be a primary key?

697


Where is sql database stored?

687


How to run sql*plus commands in sql developer?

800


What are records give examples?

743


What are different types of triggers?

738


what is recursive stored procedure? : Sql dba

714


Mention what does plv msg allows you to do?

855


What does t sql mean?

702


Is sql port 1433 encrypted?

778


What are character functions?

804