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

How to handle bulk data?

0 Answers  


Does mysql_real_escape_string prevent sql injection?

0 Answers  


Differentiate pl/sql and sql?

0 Answers  


What version is sql?

0 Answers  


If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?

9 Answers   JPMorgan Chase,






What port does sql server use?

0 Answers  


Why left join is used in sql?

0 Answers  


what are different types of keys in sql?

0 Answers  


Can we create a trigger on view?

0 Answers  


How do you update a value in sql?

0 Answers  


What is cascade in sql?

0 Answers  


Can we join 3 tables in sql?

0 Answers  


Categories