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 |
Explain a segment?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What are the predefined tablespaces in a database?
How to get a list of all user accounts in the database?
Explain the truncate in oracle?
Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou
What is merge statement used for?
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?
How to get a list of all tables in the database?
What are the commands youd issue to show the explain plan for select
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records