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 trigger in pl sql with examples?

0 Answers  

---

What is the usage of sql functions?

0 Answers  

---

what is the difference between join and union? : Sql dba

0 Answers  

---

How to combine two stored procedures in sql?

0 Answers  

---

How to call the function and Procedure in trigger?

3 Answers   IBM,

---

What is normalization ?

9 Answers   BirlaSoft, CTS, HCL,

---

Is sql a backend?

0 Answers  

---

why should required for Indexed by table in pl/sql

3 Answers  

---

Is sql a scripting language?

0 Answers  

---

Which is the best place to learn hadoop?

1 Answers  

---

What is difference between procedure and trigger?

0 Answers  

---

What is sqlerrm?

0 Answers  

---