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
- 9623 Views
- I also Faced
- E-Mail Answers
Answer Posted / santosh
show error package <package name>
to check the compilation errors
similarly for functions
show error function <function name>
and for procedures
show error procedure <procedure name>
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between dropping a database and taking a database offline? : sql server DBA
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 different types of upgrades that can be performed in sql server? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
what functionality does oracle provide to secure sensitive information?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What happens on checkpoint? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What are the steps you will take to improve performance of a poor performing query?
What would you do with an "in-doubt" distributed transaction?
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 commands used in dcl? : sql server DBA
