what is variable in package specification
Answers were Sorted based on User's Feedback
Answer / suresh somayajula
variable which is declared in a paackage specification is
global to the package and local to the Schema.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / madhuri
Variables declared in package specification are known as
global variables
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / kiran r
Package specification is the declaration of public variables such as Cursors, Objects, Procedures, Functions and Exceptions.
| Is This Answer Correct ? | 0 Yes | 0 No |
Inline the values in PL/SQL, what does it mean.?
What are the types of join and explain each?
Why do we use %rowtype & %type in plsql?
Why self join is used in sql?
When the mutating error will comes? and how it will be resolved?
How does one load ebcdic data? : aql loader
what is the difference between truncate and drop statements? : Sql dba
what is the difference between nested subquery and correlated subquery?
Mention what is the plv (pl/vision) package offers?
What is union and union all keyword in sql and what are their differences?
differentiate between float and double. : Sql dba
What is self-join and what is the requirement of self-join?
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)