Answer / guest

You add the keyword "WITHHOLD" to the declare statement of
the cursor

select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?

2 Answers  

---

Why do chiropractors use drop table?

0 Answers  

---

What do you mean by NOT NULL? When will you use it?

3 Answers  

---

Why use RUNSTAT Utility?

3 Answers   Merrill Lynch,

---

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,

---

What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

1 Answers   Cap Gemini,

---

Do we need cursor for Count(*)?

4 Answers   iGate,

---

How is the SUBSTR keyword used in sql?

1 Answers  

---

How to fetch the last row from the table in SQL (db2)?

0 Answers  

---

What is the error code -803 ?

3 Answers  

---

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers  

---

What is an instance database?

0 Answers  

---