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
What is fill factor? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What the different types of replication and why are they used? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
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.
What are the commands used in dcl? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
What purpose does the model database server? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
how can you find out if a table can be redefined?