Answer Posted / suraj kedia

There are 3 ways to find out the nth highest salary in a
given table (e.g. emp) as below;

1) select distinct sal from emp e1 where &n=(select count
distinct sal from emp e2 where e1.sal <=e2.sal);


2) select empno,enaame,sal,deptno,rank () over (order by sal
desc) as ra from emp where ra=&n;

3) select empno,enaame,sal,deptno,dense_rank () over (order
by sal desc) as ra from emp where ra=&n;


All the above methods are tried n tested....it works
successfully.




What is a Cursor.

When a query is executed in oracle, a result set is produced
and stored in the memory. Oracle allows the programmer to
access this result set in the memory through cursors.

Why use a cursor?

Many times, when a query returns more than one row as a
result, we might want to go through each row and process the
data in different way for them. Cursor is handy here.

Types of cursors:

Oracle PL/SQL declares a cursor implicitly for all queries
and DML statements (including queries that return only one
row). But in most of the cases we don’t use these cursors
for queries that return one row. Based on this, there are 2
types of cursors

1. Explicit cursor
2. Implicit cursor

How many number of sessions can one group in batches?

1139

---

Differentiate between sessions and batches?

997

---

What is the use of target designer?

1021

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2254

---

what is SDLC way of code development?

2017

---

How to handle decimal places while importing a flatfile into informatica?

1175

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1965

---

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2846

---

what is the size of u r source(like file or table)?

2251

---

How to update source definition?

1073

---

How to create the source and target database connections in server manager?

1071

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1975

---

What is mapplet in informatica?

1037

---

What are connected or unconnected transformations?

1097

---

What are the tasks that can be performed using sq?

1074

---