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

How do you truncate?

913

How bulk collect improves performance?

1011

What does a pl/sql package consist of?

979

What is the difference between the implicit and explicit cursors?

1054

Can I call a procedure inside a function?

1016

What is ttitle and btitle?

1066

How do I restart sql?

979

What is sql resultset?

991

What is cost in sql execution plan?

989

Can a key be both primary and foreign?

999

What is foreign key sql?

993

Which is better join or subquery?

1141

What does the hierarchical profiler does?

1062

what is meant by nl2br()? : Sql dba

1047

define sql update statement ? : Sql dba

1124