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.

Why plvtab is considered as the easiest way to access the pl/sql table?

0 Answers  

---

What is the difference between unique and primary key constraints?

0 Answers  

---

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

---

Is it possible to access the current value in a session before accessing next value?

1 Answers  

---

What is posting?

0 Answers  

---

hi..........i m Accenture employee...Accenture is an IT company having itz branches in India at Mumbai, Pune,Delhi, Hyderabad, Chennai and Bangalore....Presently there are openings here for SAP, Testing, Oracle,Java,.NET,MAinframe and Peoplesoft...... I am a software engineer working with Accenture,Mumbai....u can mail me in your resume..i`ll forward it to our HR team...my mail id: pankit.lodaya@accenture.com

8 Answers   Wipro,

---

how can create data base link for tow servers (scott schema) give examples plz

2 Answers  

---

What is sap sql anywhere?

0 Answers  

---

Does oracle roll back the transaction on an error?

0 Answers  

---

What are sql commands?

0 Answers  

---

What are the ddl commands?

0 Answers  

---

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;

10 Answers  

---