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.

Answer / shail

Remeber two things:

1. Global to package - declared in package body (outside
and procedure)

2. Global to database - declared in package specification

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)

What is bulk collect in pl sql?

0 Answers  

---

When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?

2 Answers   Accenture, Unisoft Infotech,

---

What is anonymous block in sql?

0 Answers  

---

what are local and global variables and their differences? : Sql dba

0 Answers  

---

write a query to find 4th max salary

7 Answers  

---

What schema means?

0 Answers  

---

what is Difference between Having and Where clause?

5 Answers   IBM,

---

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

0 Answers  

---

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

0 Answers  

---

why sql is used as interpreter frequently rather than a compile?

1 Answers  

---

what is denormalization. : Sql dba

0 Answers  

---

Is it possible to pass parameters to triggers?

0 Answers  

---