Answer / s

If the SELECT privilege is granted to PUBLIC, Yes.
Otherwise privilege has to granted explicitly.

What is the difference between a package and a plan?

6 Answers   Infosys, L&T, Mphasis,

---

What are host variables in db2?

0 Answers  

---

What is cursor?

2 Answers  

---

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,

---

In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

1 Answers   HCL,

---

---

List down the types of triggers in the db2 database?

0 Answers  

---

Can i insert bulk records into a db2 table using qmf of spufi only............!!!

2 Answers  

---

Could anyone clearly explain the diference between sub query and correlated sub query?

3 Answers  

---

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,

---

Where is the access path logic created by the DB2 Optimizer stored?

1 Answers  

---

Describe the elements of the SELECT query syntax?

3 Answers  

---

What keyword does an SQL SELECT statement use for a string search?

2 Answers  

---