table -
new_no old_no
2345 1234
3456 2345
5678 4567
output sud be -new_no
1234
2345
3456
4567
5678
Answers were Sorted based on User's Feedback
Answer / bibhu
select new_no as new_noz
from t01
union
select old_no as new_noz
from t01
order by new_noz
Is This Answer Correct ? | 10 Yes | 0 No |
What is varray in pl sql?
What is a sql schema used for?
How do you rename a table in sql?
what is indexing, searching and user interface?
How to install oracle sql developer?
What is meant by Join? What are the different types of Joins available? Explain.
Explain the structure of pl/sql in brief.
What programs use sql?
How to create a view on a table which does not exists
How to select random rows from a table?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
Which data type is a composite type?