create or replace view testView
as
select username, account_status, user_id from dba_users where username like 'S%'
with check option;
update testView
set username = 'SCHEMA'
where user_id = '92';
select * from testview;
alter view testview modify user_id unique;
create unique index testview_user_id on testview (user_id);