I have created a view, called april_may. I need to select this view by combineing to fields in the database to create the view name etc …
Create view as select * from table_X;
I need to do something like this …
Select * from (select table.start_month||_||table.end_month);
==================
Start_month = april
End_month = May
What I what to pass to the select is the combination of the 2 fields as the view name.
Any ideas ?