what is global variable in package

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How can I tell if sql is running?

761


give the syntax of grant and revoke commands? : Sql dba

805


what is a constraint? Tell me about its various levels. : Sql dba

735


Which is better join or subquery?

793


Explain architecture of sql server notification services?

787






What is orm in sql?

723


What is information schema in sql?

765


What is varchar data type in sql?

715


how to return query output in html format? : Sql dba

851


Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

657


Can we use ddl statements in stored procedure?

881


How to get unique records from a table?

684


discuss about myisam key cache. : Sql dba

763


What is auto increment feature in sql?

819


Which function is used to return remainder in a division operator in sql?

786