Answer Posted / glibwaresoftsolutions
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
What is gpt format?
Explain the purpose of %type and %rowtype data types with the example?
How do I find sql profiler?
What are dml commands?
What is the command used to fetch the first 5 characters of a string?
What does subquery mean in sql?
What is a boolean in sql?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
What is the difference between delete and truncate statement in sql?
How does sql store data?
Can we write ddl statements in functions?
What is foreign key and example?
how to dump a table to a file with 'mysqldump'? : Sql dba
What is 19 null in sql?
what are the difference between clustered and a non-clustered index? : Sql dba