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)

Can a view be updated/inserted/deleted?If Yes under what conditions?

3 Answers  

---

What is a natural join sql?

0 Answers  

---

What is form and report?

0 Answers  

---

What is difference between stored function and application function?

0 Answers  

---

What is difference between function and trigger?

0 Answers  

---

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?

3 Answers   Oracle,

---

What are different types of keys?

0 Answers  

---

what is organisational index?

1 Answers  

---

how to increment dates by 1 in mysql? : Sql dba

0 Answers  

---

What is range partitioning?

0 Answers  

---

what is uncommittable transactions? : Transact sql

0 Answers  

---

What is difference between a PROCEDURE & FUNCTION ?

6 Answers   Satyam,

---