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  






Categories