Answer / suresh somayajula

variable which is declared in a paackage specification is
global to the package and local to the Schema.

Answer / madhuri

Variables declared in package specification are known as
global variables

Answer / kiran r

Package specification is the declaration of public variables such as Cursors, Objects, Procedures, Functions and Exceptions.

what is oltp (online transaction processing)? : Sql dba

0 Answers  

---

Mention what pl/sql package consists of?

0 Answers  

---

I want to know the difference between A Record Type and a Table.

3 Answers   Thermotech,

---

how to retrieve only duplicate values in a table

9 Answers  

---

Write a query to display the current date in sql?

0 Answers  

---

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

---

How is sql used in oracle?

0 Answers  

---

What is union?

0 Answers  

---

Why we use triggers in mysql?

0 Answers  

---

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---

How do you get column names only for a table (sql server)?

0 Answers  

---

Is left join inner or outer?

0 Answers  

---