Answer / hemant

Interprter works line by line but compiler execute its all
work as a program..like if any sql query has error then sql
will how that x line has error ..

What is the command used to fetch the first 5 characters of a string?

0 Answers  

---

what is online transaction processing (oltp)? : Sql dba

0 Answers  

---

wtite down triggr not any entry on Sunday

2 Answers   NIT,

---

What is dense_rank?

0 Answers  

---

Can I create table without primary key?

0 Answers  

---

---

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,

---

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

3 Answers   JPMorgan Chase,

---

Who developed sql?

0 Answers  

---

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance

5 Answers   Target,

---

what is the Default Libraries for Oracle Report 6i

0 Answers   IBM,

---

Is a view faster than a stored procedure?

0 Answers  

---

What are the datatypes a available in PL/SQL ?

2 Answers  

---