What a SELECT FOR UPDATE cursor represent.?

1 Answers  

---

How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?

2 Answers   Infosys,

---

write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.

11 Answers   Wipro,

---

How would you best determine why your MVIEW couldnt FAST REFRESH?

0 Answers  

---

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

1 Answers  

---

I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??

1 Answers  

---

What is the difference between column level constraints and table level constraints?

14 Answers   IBM, TCS,

---

How do I call oracle stored procedures that take no parameters?

0 Answers  

---

How to calculate date and time differences in oracle?

0 Answers  

---

what are the different types of cursors? explain?

4 Answers  

---

How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10

2 Answers  

---

What is Redo Log Buffer in Oracle?

0 Answers   MCN Solutions,

---