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

Mention what is the use of function "module procedure" in pl/sql?

1088

What is a table?

1058

What are the features of pl sql?

1110

Explain character-manipulation functions?

1176

Does asenumerable execute the query?

1097

How do I run a sql trace?

1003

What is trigger explain with example?

1092

Is sql better than excel?

1224

Why is sql better than hql?

1063

What are the different schemas objects that can be created using pl/sql?

1085

What is full join?

1019

What is a procedure in pl sql?

1287

What do we need to check in database testing?

1063

Does sql*plus also have a pl/sql engine?

1131

Why do we need cursor in pl sql?

1187