Skip to content

Instantly share code, notes, and snippets.

@vipassanaecon
Last active January 4, 2022 23:14
Show Gist options
  • Save vipassanaecon/5bdcd939d9d2988e34f01213766be941 to your computer and use it in GitHub Desktop.
Save vipassanaecon/5bdcd939d9d2988e34f01213766be941 to your computer and use it in GitHub Desktop.
Update example script 1
-- Update example script 1
= "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 = '"&B6&"'
)
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 = '"&C6&"'
and tf.table_function_name = '"&D6&"'
)
and region_name = '"&E6&"';"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment