what are the different types of cursors? explain?

4 Answers  

---

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

1 Answers  

---

How to Identify the previously inserted/updated records in already populated table.

0 Answers  

---

can u call user defined functions in select statements

2 Answers  

---

I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.

4 Answers  

---

how to join query for one source type is oracle another source type is sql server ?

0 Answers   iGate,

---

why dont we assign not null constraint as table level constraint.

0 Answers  

---

What are the general rules on data consistency?

0 Answers  

---

create one table to capture an employee details with a primary key.

1 Answers   CTS,

---

Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.

1 Answers  

---

What does sharding mean?

0 Answers  

---

What is Segment Advisor in Oracle?

0 Answers   MCN Solutions,

---