Create dynamic view

Create dynamic view.

Last updated: 19 September 2016

Warning: Review and test in a non-production environment before running.

Back to results

create view myview as
select * from ABC_TEMP
where user_id = userenv('client_info');

/ exec dbms_application_info.set_client_info('1422488');

select * from myview;