I have created one package with out procedures in package specification and in

I have created one package with out procedures in package
specification and in package body i have used 2 procedures. is
it compile????

Question Posted / eshwer

1 Answers
4774 Views
I also Faced
E-Mail Answers

I have created one package with out procedures in package specification and in package body i have..

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

Post New Answer

More Oracle General Interview Questions

why can't we assign not null constraint as table level constraint

3 Answers CTS, Wipro,

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

0 Answers

4. Using a set operator, display the creditor number of all creditors who have ever been paid.

2 Answers Wipro,

Q1:code to connect to sql server(database) through jdbc application. Q2:code to connect to Mysql(database) through jdbc application. Q3:code to connect to oracle(database) through jdbc application.

1 Answers

6. Display the client name and order date for all orders using the traditional method.

0 Answers Wipro,

What is a synonym? What are its various types?

0 Answers

how to get count of tables in particular database in Oracle?

3 Answers

What are the trigger associated with image items ?

1 Answers Oracle,

How to create a stored function in oracle?

0 Answers

types of indexes and the rationale behind choosing a particular index for a situation.