You have just compiled a PL/SQL package but got errors, how
would you view the errors?
Answer Posted / priya reddy
show error;
This is the command used to view the errors..
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Where do you find the default index fill factor and how to change it? : sql server DBA
what is the use of recording information about current session?
what is the role of dip user in our database?
What is the importance of a recovery model? : sql server DBA
how can you process messages in order asynchronously?
how can you record information about current session?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What is a correlated sub-query? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?