asked on 4/13/2016

Oracle - Case clause issue

Hi,

I have a query that i would like to insert a CASE that if TRT.trlr_type_id LIKE ('%HTD%') then i need to put '0' in the column TRT.current_num_vehicles of the same row.

I tried like below but i get an error:
Error report -
Unknown Command

Select ...
CASE
  WHEN TRT.trlr_type_id LIKE ('%HTD%') THEN TRT.current_num_vehicles = '0';
  WHEN TRT.trlr_type_id LIKE ('%HEAT%') THEN TRT.current_num_vehicles ='0';
  ELSE TRT.current_num_vehicles
  END AS NUM_VAL,

Open in new window

How can i do that?
Thank you for your help

Oracle Database SQL

Last Comment

Wilder1626

4/13/2016

ASKER CERTIFIED SOLUTION

Alex [***Alex140181***]

4/13/2016

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

SOLUTION

Helena Marková

4/13/2016

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Wilder1626

4/13/2016

ASKER

ok, so from what i see, you cannot override another column value. right?

I can only populate the result in the column NUM_VAL.

I have a column in my query called TRT.current_num_vehicles and i wanted to update that column value with a ZERO and not the column NUM_VAL.

Wilder1626

4/13/2016

ASKER

Thanks, i will use this instead of looking after change another column value.