Update example script 3

Update example script 3.sql

-- Update example script 3 (final)
update region_table
set isopen = 'Y'
,   isavailable = 'N'
,   isrestricted = 'Y'
,   user_last_modified = 'user_migration'
,   date_last_modified = sysdate
where state_plan_id      =   (
                              select table_id
                              from state_table st
                              where st.table_code  = 'NY'
                              )
and   table_function_id  =   (
                              select table_function_id
                              from table_function  tf
                              join table_area      ta  on  tf.table_area_id = ta.table_area_id
                              where ta.table_area_name     = 'Production'
                              and   tf.table_function_name = 'Production Utility Demo'
                              )
and   region_name        = 'New York East District';