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 ?