Answer / priya reddy

show error;
This is the command used to view the errors..

Answer / santo

Sometimes 'Show error' won't display the required
info...then check dba_errors table

select text from dba_errors where name='****';

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>

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

---

How many packages we have in db

1 Answers   Tesco,

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers  

---

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers  

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  

---

---

How would you go about increasing the buffer cache hit ratio?

2 Answers  

---

how can you get actual data change values from previous transactions in oracle?

0 Answers   Oracle,

---

how can you enable flashback feature?

0 Answers   Oracle,

---

what is ora 600?

1 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

---

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---