What is embedded sql with example?

0 Answers  

---

if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

1 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  

---

Differentiate between sga and pga.

0 Answers  

---

How many types of tables are there?

0 Answers  

---

---

What is the difference between nested table and varray?

0 Answers  

---

What are the parts of a sql statement?

0 Answers  

---

What are the three pl sql block types?

0 Answers  

---

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

0 Answers  

---

Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.

5 Answers   Thomson,

---

select top 3 sal from each dept?

17 Answers   IBM, TCS,

---

What is sqlerrm?

0 Answers  

---