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

Is it mandatory for the primary key to be given a value when a new record is inserted?

0 Answers  

---

What are hotfixes and patches?

0 Answers  

---

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  

---

is it necessary to write group by and order by clause together

3 Answers   HCL, Wipro,

---

How do you delete duplicates in sql query using rowid?

0 Answers  

---

---

How to recompile a already made trigger?

2 Answers  

---

what is global temporary tables and how use that tables in pl/sql packages

1 Answers   Cap Gemini,

---

How to revise and re-run the last sql command?

0 Answers  

---

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?

8 Answers   L&T,

---

What is the function that is used to transfer a pl/sql table log to a database table?

0 Answers  

---

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B

2 Answers   Fintellix,

---

What are the features of pl sql?

0 Answers  

---