Interested to Buy Any Domain ? << Click Here >> for more details...
I have created one package with out procedures in package
specification and in package body i have used 2 procedures. is
it compile????
- 1 Answers
- 4638 Views
- I also Faced
- E-Mail Answers
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.
| Is This Answer Correct ? | 6 Yes | 0 No |
You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.
What is dual table oracle?
What is RULE-based approach to optimization ?
How to select some columns from a table in oracle?
What is columnar storage what is the advantage?
Find all employees in Dept “Marketing”.
defination of bitmap index
how to find the n'th highest salary from emp ?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
How to create a new tablespace in oracle?
how to use sequence and what use of sequence cache
What to do if the startbd.bat failed to start the xe instance?
Oracle General 
