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 |
there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?
How to remove duplicate rows from a table?.
what are the different index configurations a table can have? : Sql dba
one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?
Mention what plvcmt and plvrb does in pl/sql?
What is sql deadlock?
Explain the uses of a database trigger?
Can you sum a count in sql?
How many types of index are there?
What is sql engine in oracle?
What does count (*) do in sql?
How do you add a column to a table?
Oracle (3259)
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)