What is correlated sub-query?

7 Answers   Oracle,

---

What are the modes of parameters that can be passed to a procedure ?

3 Answers  

---

Talk about views

10 Answers   Polaris,

---

Types of joins?

4 Answers   Microsoft,

---

What are types of indexes in sql?

0 Answers  

---

---

What is difference between pls_integer and integer?

0 Answers  

---

Can u create a primary key with out unique index.

8 Answers  

---

Can you rollback after commit?

0 Answers  

---

What is primary key and foreign key with example?

0 Answers  

---

Explain the steps needed to create the scheduled job?

0 Answers  

---

Is sql a backend?

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  

---