Query help

[JasonMcConnell]

Hi,
I have just started teaching myself SQL plus and was wondering how I can update multiple records (application numbers that I can define)
E.g.
update application_table
Set closed ='Y' where application_number = '20008121'

What I would like to do is to be able to define multiple application numbers

update application_table
Set closed ='Y' where application_number = '20008121', '20086563', 200812625;

Thanks for your help

 

[taupirho]

Nearly, try this

update application_table
Set closed ='Y' where application_number in('20008121', '20086563', 200812625)


In order to understand recursion, you must first understand recursion.