Why is the cursor important?

0 Answers  

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

0 Answers  

---

What is mdb stand for?

0 Answers  

---

Write a query to find the employees from EMP table those who have joined in Monday. (there is a column as hiredate which is a date column i.e values are like 03-DEC-81)

5 Answers  

---

How does sql developer connect to oracle database?

0 Answers  

---

---

how do you login to mysql using unix shell? : Sql dba

0 Answers  

---

Why do we create views in sql?

0 Answers  

---

how many no of table can be join in a sql query.

4 Answers  

---

what is julian date in oracle

2 Answers  

---

What is difference between group by and partition by?

0 Answers  

---

What is synchronized subquery?

0 Answers  

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

0 Answers  

---