what is global variable in package
Answers were Sorted based on User's Feedback
Answer / useroracle
Global variable or subprogram(procedure,function) that can
be referenced outside the package and is visible to
external users user is called global variable. Global
package items must be declared in the package specification.
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / shail
Remeber two things:
1. Global to package - declared in package body (outside
and procedure)
2. Global to database - declared in package specification
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / vidya
Defining a Global variable is practically restricted,
Beco'z Renaming a Package is very nasty things, our
Database always available in Tree Structure. But Global
variable determined by whether you declare the variable
outside in the package (global)/ Procedure (global).
Declaring a variable in the body or the specification
determines if the variable is public (specification) or
private (body)
Is This Answer Correct ? | 2 Yes | 3 No |
what are the different types of joins?
what does the t-sql command ident_current does? : Transact sql
Why is a trigger used?
Is trigger a stored procedure?
Which is faster count (*) or count 1?
Do view contain data?
Why are cursors used?
Why do we need databases?
what is the difference between trigger and constraint?
What is the difference between left join and left outer join?
What is numeric function sql?
Mention what are the benefits of pl/sql packages?