-
Update using CASE statement - can't see it.
Havin' a bad day.........
What's wrong with this
UPDATE PHILTEST SET TYPE =
CASE DATE1
WHEN '05-NOV-03' THEN 'CR'
WHEN '01-DEC-03' THEN 'TN'
WHEN '01-JAN-04' THEN 'RV'
END CASE;
END CASE
*
ERROR at line 6:
ORA-00933: SQL command not properly ended
-
UPDATE PHILTEST SET TYPE =
CASE DATE1
WHEN '05-NOV-03' THEN 'CR'
WHEN '01-DEC-03' THEN 'TN'
WHEN '01-JAN-04' THEN 'RV'
END;
-
That did it. Only use 'END CASE' within a PL/SQL block... Thanks.
The final solution....
UPDATE PHILTEST SET TYPE =
CASE to_char(DATE1,'DD-MON-YY')
WHEN '05-NOV-03' THEN 'CR'
WHEN '01-DEC-03' THEN 'TN'
WHEN '01-JAN-04' THEN 'RV'
ELSE TYPE
end
where to_char(date1,'DD-MON-YY')
in ('05-NOV-03','01-DEC-03','01-JAN-04');
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|