SQL Oracle/Concat and then use it in select * from

I want to define a variable for further use in the query.