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)

How much does sqlite cost?

0 Answers  

---

Is sql better than excel?

0 Answers  

---

what is a table in a database ? : Sql dba

0 Answers  

---

What is a Mapplet?

0 Answers   Informatica,

---

What is pl sql and why it is used for?

0 Answers  

---

How do I turn a list into a table?

0 Answers  

---

what is schema? : Sql dba

0 Answers  

---

will function return more than one value how

9 Answers   Accenture,

---

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

0 Answers   BT,

---

Is grant a ddl statement?

0 Answers  

---

What is character functions?

0 Answers  

---

When are we going to use truncate and delete?

0 Answers  

---