select c1 as c1 from t1 union select c2 as c1 from t1; try this one.

----> There is a table T with two columns C1 and C2.
The data is as below:
C1 C2
1 4
2 5
3 6

Question Posted / ramaraju

Answer Posted / ramaraju

select c1 as c1 from t1
union
select c2 as c1 from t1;

try this one.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is difference between pl and sql?

992

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1141

How do you use a while loop in pl sql?

940

How do you declare a constant?

910

What is the difference between the conventional and direct path loads? : aql loader

1315

What are the uses of merge?

1119

What is the purpose of the partition table?

1002

How many types of cursors supported in pl/sql?

1093

What is data modelling in sql?

962

How do I save a stored procedure?

946

Can we insert delete data in view?

898

How do I edit a trigger in sql developer?

935

Explain the purpose of %type and %rowtype data types with the example?

926

What is trigger in pl sql with examples?

979

What is input buffer in sql*plus?

1123