Home » SQL & PL/SQL » SQL & PL/SQL » Update Statement - Urgent
Update Statement - Urgent [message #4482] Fri, 13 December 2002 13:04 Go to next message
Prabhu
Messages: 26
Registered: October 2001
Junior Member
What could be the possible problem.

update new_tdmcust set
mdb_valid_state_ind = case
when cust_fa_flag = 'Y' then 'N'
when cust_fa_flag = 'N' then case when cust_st in
(select state_code from valid_states ) then 'Y' else 'N' end end

when cust_fa_flag = 'Y' then 'N'
*
ERROR at line 3:
ORA-00933: SQL command not properly ended

Report message to a moderator

Re: Update Statement - Urgent [message #4483 is a reply to message #4482] Fri, 13 December 2002 15:03 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
The syntax is valid - you would need to be on 8.1.6 or later though.

Report message to a moderator

Previous Topic: Package Access
Next Topic: Urgent
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 15 23:48:30 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.