What is dynamic SQl and how you will create and execute dynamic sql?

2 Answers   TCS,

---

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,

---

How many triggers can be applied to a table?

0 Answers  

---

How does one use sql*loader to load images, sound clips and documents? : aql loader

0 Answers  

---

What is sql rowcount?

0 Answers  

---

---

Can we use ddl commands in pl sql?

0 Answers  

---

Can there be 2 primary keys in a table?

0 Answers  

---

What is sqlite used for?

0 Answers  

---

Types of cursors and explanation each of them ?

4 Answers   DELL,

---

What is a file delimiter?

0 Answers  

---

Does pl sql work in mysql?

0 Answers  

---

I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS

7 Answers   Polaris,

---