Skip to content

Instantly share code, notes, and snippets.

@vipassanaecon
Last active January 4, 2022 23:16
Show Gist options
  • Save vipassanaecon/2a367e95f467e5ecd023500f57c16abe to your computer and use it in GitHub Desktop.
Save vipassanaecon/2a367e95f467e5ecd023500f57c16abe to your computer and use it in GitHub Desktop.
Update example script 2
-- Update example script 2
"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';"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment