Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / hr@tgksolutions.com
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
Is primary key clustered or nonclustered?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
Why indexing is needed?
What is difference between procedure and trigger?
What is the difference between delete, truncate and drop command?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
Explain lock escalation? : Transact sql
What is delimiter sql?
Can we write ddl statements in functions?
What are the rules to be applied to nulls whilst doing comparisons?
What is a primary key sql?
Can we call a function containing dml statements in a select query?
What is mdb stand for?
What is the difference between Union and Union all. Which is faster.
