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 many disk partitions should I have?

0 Answers  

---

How many types of index are there?

0 Answers  

---

SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/

1 Answers   Accenture,

---

What are the basic techniques of indexing?

0 Answers  

---

what are wild cards used in database for pattern matching ? : Sql dba

0 Answers  

---

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

0 Answers  

---

Explain two easy sql optimizations.

0 Answers  

---

Does postgresql run on the cloud?

0 Answers  

---

What is the usage of sql functions?

0 Answers  

---

Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

1 Answers  

---

How do I order by ascending in sql?

0 Answers  

---

Explain what is a field in a database and record in a database?

0 Answers  

---