how to hide the stored procedure inside a package

how to hide the stored procedure inside a package..

Answer / ganesh galla

we should create private procedure in package, then it wont be accessible outside of the package.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle General Interview Questions

What are different Oracle database objects?

1 Answers  

what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?

2 Answers  

what is host string in sql plus? how does it related to database?

1 Answers  

What is Partitions in Table ?

2 Answers   Atiric Software,

Explain the concept of the DUAL table.

2 Answers  

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

0 Answers  

Which is better Oracle or MS SQL? Why?

2 Answers   Bally Technologies,

sql query to get zero records from a table

7 Answers   CTS,

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

0 Answers  

what is RAID technology?which is better RAID 0+1 OR RAID 5?

2 Answers   CSC,

What are the Limitations of a CHECK Constraint ?

5 Answers  

What is a Database instance ? Explain?

3 Answers