when i execute the statement,
update tblpat_History set Category='circulation' , CHKCAbdominal='03-03-2000' , where accountnumber='100092'

it is giving an error as:

Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'where'.


suggest me:


CONFIDENTIALITY NOTICE: This e-mail and its attachments may contain PRIVILEGED and CONFIDENTIAL INFORMATION and/or PROTECTED PATIENT HEALTH INFORMATION intended solely for the use of Tranquilmoney Inc. it's clients and the recipient(s) named above. If you are not the intended recipient, or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any review, dissemination, distribution, printing, or copying of this e-mail message and/or any attachments is strictly prohibited. If you have received this transmission in error, please notify the sender immediately and permanently delete this e-mail [shred the document] and any attachments.




Oracle LazyDBA home page