Change view name dynamically

Hi @hewelkw ,

You can do it using the variable ‘p_sViewName’. But I hope you know how to handle this since it will need to consider other things like security, column, loading, package Etc.

It will be easy if you search for the variable ‘p_sViewName’ in PAYLED module. You will find many examples there, so you can get an idea about how to do it.

You might consider making a union view to achieve this on the database.

SELECT * FROM view_one WHERE condition = TRUE
UNION ALL
SELECT * FROM view_two WHERE condition = FALSE