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)

difference between table level constraint and column level and advantages of table level constraint

4 Answers   Doyensys,

---

What does count (*) mean in sql?

0 Answers  

---

how will you find out the last three records in a table with n no of records and delete them

3 Answers  

---

What is vector point function?

0 Answers  

---

When to use inner join and left join?

0 Answers  

---

Can We write bulk collect statement in triggers?

1 Answers   Polaris,

---

what are the 'mysql' command line arguments? : Sql dba

0 Answers  

---

Does postgresql run on the cloud?

0 Answers  

---

How to read xml file in oracle pl sql?

0 Answers  

---

How do I install microsoft sql?

0 Answers  

---

How are sql commands classified?

0 Answers  

---

What are the commands used in sql?

0 Answers  

---