Explain an outer join?

1 Answers  

---

when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations

3 Answers   IBM,

---

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,

---

How does a cursor work?

0 Answers  

---

What is bind plan?

0 Answers  

---

---

What is cursor in dbms?

0 Answers  

---

What is a Foreign Key?

0 Answers   Tavant Technologies, Zensar,

---

Which one allows duplicate values Union or Union All ?

3 Answers  

---

What is -904 sql code? How to resolve it?

3 Answers  

---

what is a plan and how do you refer the plan in the program?

2 Answers   Xansa,

---

Update command

1 Answers  

---

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---