Answer Posted / bibhu

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

how to escape special characters in sql statements? : Sql dba

1127

---

what is schema? : Sql dba

1165

---

Is inner join faster than left join?

1289

---

Can delete statement be rollbacked?

1066

---

Can we rollback truncate?

1088

---

how many tables will create when we create table, what are they? : Sql dba

1158

---

what is sql server agent? : Sql dba

1192

---

What is the current version of sql?

1107

---

what are the advantages of sql ? : Sql dba

1155

---

Do we need to rebuild index after truncate?

1156

---

What is your daily office routine?

2354

---

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

2103

---

Can we use distinct and group by together?

1149

---

Is primary key always clustered index?

1102

---

what is dbms? : Sql dba

1073

---