Answer / bibhu

select new_no as new_noz
from t01
union
select old_no as new_noz
from t01
order by new_noz

Answer / lizamishra15

pls send me th answer

How many clustered indexes can be created on a table?

0 Answers  

---

State the difference between implict and explict cursor's?

7 Answers   CTS,

---

Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

1 Answers  

---

What is a join query?

0 Answers  

---

What is substitution variable?

0 Answers  

---

how can you create an empty table from an existing table? : Sql dba

0 Answers  

---

what is the output of this query selet * from employee where 1=2 ??

11 Answers  

---

What is clustered index in sql?

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 sql clause?

0 Answers  

---

What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?

1 Answers   ABC,

---

How can analyze query after generating explain plan ?

2 Answers   Thermotech,

---