Home » SQL & PL/SQL » SQL & PL/SQL » Urgent
Urgent [message #23507] Fri, 13 December 2002 12:02 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: Urgent [message #23510 is a reply to message #23507] 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: Update Statement - Urgent
Next Topic: SQL plus
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 16 15:39:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.