create or replace view active_toys as select * from toys where is_deleted = 'N'; select * from active_toys;