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 the different types of replication and why are they used? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
how can you process messages in order asynchronously?
What purpose does the model database server? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is dbcc? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
What is the difference between dropping a database and taking a database offline? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
what are the performance views in an oracle rac environment?
What is the default fill factor value? : sql server DBA
What is the importance of a recovery model? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA