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 do I turn a list into a table?

0 Answers  

---

What is the use of count (*) in sql?

0 Answers  

---

table :- city name country code abc 11 bcd 22 cde 232 def 33 write a procedure , so that when we give a phone no. eg - 1123456789 - o/p sud be city name = abc if phone no. - 2322345897 , o/p sud be =cde note - bcd and cde city name sud be diff. as dey diff only with th last no. Pls ans. this questnion.

1 Answers  

---

How can the performance of a trigger be improved?

0 Answers  

---

What is rownum and rowid?

0 Answers  

---

---

What is a variable in sql?

0 Answers  

---

Is sql scripting language?

0 Answers  

---

Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index

2 Answers   Polaris,

---

Is id a reserved word in sql?

0 Answers  

---

how tsql statements can be written and submitted to the database engine? : Transact sql

0 Answers  

---

What port does sql server use?

0 Answers  

---

What does an inner join do?

0 Answers  

---