You have just compiled a PL/SQL package but got errors, how
would you view the errors?
Answers were Sorted based on User's Feedback
Answer / priya reddy
show error;
This is the command used to view the errors..
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / 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 |
Answer / 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 |
You have just compiled a PL/SQL package but got errors, how would you view the errors?
How many packages we have in db
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
What are the commands you'd issue to show the explain plan for "select * from dual"?
How would you go about increasing the buffer cache hit ratio?
how can you get actual data change values from previous transactions in oracle?
how can you enable flashback feature?
what is ora 600?
What is database replicaion? What are the different types of replication you can set up in SQL Server?
how do see how much space is used and free in a tablespace
How would you go about generating an EXPLAIN plan?