Tell me what a package consists of.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
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 |
Why do you partition data?
what is difference between pass by value and eference by value in oracle plsql
How do you handle exceptions. Give the syntax for it?
What is rownum and rowid?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
Can two tables have same primary key?
write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/
In testing where do we use sql language and how it helps in testing?
How is a PL/SQL code compiled?
What pl/sql package consists of?
Why do we use procedures in pl sql?
HP Interview -2016 Unix 1) grep command in unix 2) what is set command
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)