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 is minus?

0 Answers  


What is the Query to print out the individual total number of duplicate row in sql.

5 Answers   TCS,


Does sql full backup truncate logs?

0 Answers  


HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM

3 Answers  


What is a pragma statement?

0 Answers  






What is schema in sql?

0 Answers  


i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  


What is mutating table error?

0 Answers  


What is foreign key and example?

0 Answers  


What does inner join mean?

0 Answers  


Which one is better subquery or joins?

0 Answers  


What is sql*plus?

0 Answers  


Categories