What is difference between group by and partition by?

0 Answers  

---

What does desc stand for?

0 Answers  

---

What is trigger in pl sql with examples?

0 Answers  

---

what is cursor procedure

1 Answers   iGate,

---

Is ms sql is free?

0 Answers  

---

What is a join?Explain the different types of joins?

6 Answers   Bank Of India, CitiGroup, Google, ICICI, Saama Tech, SkyTech, TCS,

---

What is a sql*loader control file?

0 Answers  

---

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?

7 Answers   Cognizant,

---

What is a rank in sql?

0 Answers  

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

4 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 cold data?

0 Answers  

---