what is global variable in package

Answers were Sorted based on User's Feedback



what is global variable in package..

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

what is global variable in package..

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

what is global variable in package..

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

Post New Answer

More SQL PLSQL Interview Questions

what are the different types of joins?

4 Answers   Choice Solutions,


what does the t-sql command ident_current does? : Transact sql

0 Answers  


Why is a trigger used?

0 Answers  


Is trigger a stored procedure?

0 Answers  


Which is faster count (*) or count 1?

0 Answers  






Do view contain data?

6 Answers   Ramco,


Why are cursors used?

0 Answers  


Why do we need databases?

0 Answers  


what is the difference between trigger and constraint?

3 Answers   HSBC,


What is the difference between left join and left outer join?

1 Answers  


What is numeric function sql?

0 Answers  


Mention what are the benefits of pl/sql packages?

0 Answers  


Categories