Interested to Buy Any Domain ? << Click Here >> for more details...
You have just compiled a PL/SQL package but got errors, how
would you view the errors?
- 3 Answers
- 9349 Views
- I also Faced
- E-Mail Answers
Answer Posted / santo
Sometimes 'Show error' won't display the required
info...then check dba_errors table
select text from dba_errors where name='****';
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
how can you find out if a table can be redefined?
What are the steps you will take to improve performance of a poor performing query?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is transparent data encryption? : sql server DBA
what are the performance views in an oracle rac environment?
Which autogrowth database setting is good? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
how can you record information about current session?
which background process invoke at the time of upgradation tell me???
how can you schedule a job in database?
what is the role of dip user in our database?
when does an alert gets signaled?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
