What will you get by the cursor attribute sql%found?

0 Answers  

---

what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?

3 Answers   3i Infotech,

---

What is data profiling in sql?

0 Answers  

---

Which are the different case manipulation functions in sql?

0 Answers  

---

what will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,

---

---

Explain table and field in sql?

0 Answers  

---

Enlist the data types that can be used in pl/sql?

0 Answers  

---

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

---

I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.

15 Answers   Wipro,

---

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

2 Answers   TCS,

---

Can there be 2 primary keys in a table?

0 Answers  

---

How can get second highest salary in sql?

0 Answers  

---