Answer Posted / prem

SQL> select salary from(select salary,rownum a from(select salary from employee order by salary desc))where a=2;

What is a data dictionary and how can it be created?

1055

---

How to define a procedure inside another procedure?

960

---

How to test null values?

1041

---

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5330

---

How much memory your 10g xe server is using?

1050

---

how to handle exceptions in post production

1358

---

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.

2042

---

How to create id with auto_increment on oracle?

932

---

Explain database link?

1060

---

How to use like conditions in oracle?

994

---

What is Reduced List of Values?

2102

---

How to open a cursor variable?

973

---

Can we connect to ORACLE db using Windows Authentication?

1181

---

How to connect ms access to oracle servers?

944

---

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1669

---