Answer / kumar swamy naidu

YES .if we create any PACKAGE with PROCEDURE on package Specification that's called GLOBAL PACKAGE.
If We Create Any PACKAGE with out procedure in package specification and it in package body that's called PRIVATE package.
it compile with out any error.

Explain implicit cursor.

0 Answers  

---

Explain an index segment?

0 Answers  

---

what are the default admin accounts in Oracle 10g ?

0 Answers   MCN Solutions,

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance

2 Answers  

---

How to delete a user account in oracle?

0 Answers  

---

---

how to genarate random numbers in oracle for particular row?

3 Answers  

---

If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

8 Answers   IBM,

---

what are stored procedures?

7 Answers   TCS, Wells Fargo,

---

What is a synonym? What are its various types?

0 Answers  

---

if you update view? where we store the data?

5 Answers   Cap Gemini,

---

What is the max number of columns in an oracle table?

0 Answers  

---

What is different types of joins?

0 Answers  

---