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 is a call statement? Explain with an example.

0 Answers  

---

What does rownum mean in sql?

0 Answers  

---

Differentiate between pl/sql and sql?

0 Answers  

---

Explain isolation levels. : Transact sql

0 Answers  

---

Explain some predefined exceptions.

0 Answers  

---

What is Collation Sensitivity ? What are the various type ?

0 Answers  

---

what is data control language? : Sql dba

0 Answers  

---

Write a procedure to return the month and the number of developers joined in each month (cursor )

2 Answers   Tech Mahindra,

---

What is faster join or subquery?

0 Answers  

---

Mention what is the use of function "module procedure" in pl/sql?

0 Answers  

---

i want run a sql query query? which phases are run in a back ground? pls tell me the answer

1 Answers  

---

What are reports usually used for?

0 Answers  

---