Answer / tushar pramod patil

It depends on your stream of certification.
That is there are two ways in that you can complete oca that as 1)OCA under deveolper track And 2) OCA under DBA track
If you interested in developer track then i must want to tell there is no any certification in 10G for OCA , It is under 9i
Program in pl/sql is nothing bus OCA in developer track.
Now about oca under DBA track it available in9i and 10G also
in 10G for OCA u must complete sql exam and then workshop I.

Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin

5 Answers   Deloitte, Ness Technologies,

---

What is the use of sql trace?

0 Answers  

---

what is the difference between inner and outer join? Explain with example. : Sql dba

0 Answers  

---

What is the use of cursor ? how cursor allocate context area for executing the sql statement?

4 Answers   HCL,

---

Explain the rollback statement?

0 Answers  

---

difference between anonymous blocks and sub-programs.

0 Answers  

---

What is pl sql variable?

0 Answers  

---

Is nosql relational?

0 Answers  

---

If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?

9 Answers   JPMorgan Chase,

---

What is set serveroutput on in pl sql?

0 Answers  

---

What is the basic structure of an sql?

0 Answers  

---

i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.

4 Answers   TCS,

---