oracle - Trying to run multiple SQL Scripts -


i have been trying run multiple sql scripts within pl/sql developer. have tried , without '/' character, getting 'ora-00911: invalid character". have 800 update statements need correct spelling errors, punctuation , spacing.

please let me know should these work.

thank you

select *    lkup_sproj_type   description in ('single-family residential');  /   update lkup_sproj_type    set description = 'single - family residential'  description in ('single-family residential');  /  select *    lkup_sproj_type   description in ('single - family residential');  / 

have tried enclosing statements in begin... end block , removing / , keeping ;s so?

begin     select *    lkup_sproj_type    description in ('single-family residential');    update lkup_sproj_type   set description = 'single - family residential'   description in ('single-family residential');    select *    lkup_sproj_type    description in ('single - family residential');  end; 

Comments