Hello. I know it's a simplest thing but I'm stuck.
There are 5 variables from a same table: A, B, C, D and E, as below
A
-------
0.5

B
-------
1.2

etc


I want to bring each one of them back in separate rows, but as one variable (call it Level 2 for example) so the result of query will look like

Level 2 Rate
-------- --------
A 0.5
B 1.2
C 0.4
D 3.1
E 1.0

I'm working in Oracle 9.1, using SQLPlus. Any help will be welcome! Please!!

Thanks in advance
Fiona