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 are ddl statements in mysql? : Sql dba

0 Answers  

---

What is the usage of nvl function?

0 Answers  

---

what are the performance and scalability characteristics of mysql? : Sql dba

0 Answers  

---

Explain the significance of the & and && operators in pl sql.

0 Answers  

---

What are secondary keys?

0 Answers  

---

What is Materialized View? In What Scenario we Use Materialized View?

2 Answers   Dinesh, Marlabs,

---

Can I create table without primary key?

0 Answers  

---

how to create temparary sequence

2 Answers   TCS,

---

What is the difference between count 1 and count (*) in a sql query?

0 Answers  

---

What are tables and fields in the database?

0 Answers  

---

When would you denormalize?

8 Answers   MBT, Microsoft, MMU,

---

Can a table have two primary keys?

44 Answers   HCL, MetaCube,

---