SQL & PL/SQL

Hi All,

I would like to retrieve data from all similar columns in a table:

ex: desc table;

emp name
emp name1
emp name2
emp name3
---
--
emp name30
emp number
emp ph

so now i want retrieve all emp name* columns data with out selecting each one is there any short cut?

i have tried with rtrim but i am unable to get it. Could any body help me in this regard.

Thanks,
Red.