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,

---

How do I create a memory optimized filegroup?

0 Answers  

---

What is primary key and foreign key with example?

0 Answers  

---

How to return more than one value from a function?

11 Answers   Satyam,

---

Can a view be updated/inserted/deleted?If Yes under what conditions?

3 Answers  

---

What are Lexical Parameters.How They are used in Reports 6i

2 Answers   eicc,

---

Talk about views

10 Answers   Polaris,

---

What is a ddl command?

0 Answers  

---

How do I make my sql query run faster?

0 Answers  

---

I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the inner procedure in the out procedure and send the inner procedure parameter value(out parameter value) into out procedure?

2 Answers  

---

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---

What is dense_rank in sql?

0 Answers  

---