How can the firstname and the lastname from the emp table be concatenated to generate complete names?

0 Answers  

---

What is deadlock?

2 Answers  

---

How Plan is created while executing the query using SPUFI?

3 Answers  

---

What is the picture clause of the null indicator variable?

6 Answers  

---

what is plan? is plan executable or package?

4 Answers  

---

what is dynamic cursor?gives syntax for this?

1 Answers   TCS,

---

what is rebinding ?

1 Answers   IBM,

---

What is correlated subquery?

1 Answers  

---

difference between group clause and order clause

1 Answers  

---

Once you create a view, where would information about the view be stored?

1 Answers  

---

i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

2 Answers   EDS,

---

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,

---