Re: update SQL

Hi,

The UPDATE statement cannot have a FROM clause. Remove the FROM clause and
retry.

The general syntax is UPDATE table_name SET column_name=updated_value WHERE
where_clause_if_any;

Rgds,

Rakesh.
----- Original Message -----
From: "Manish Jain" <[email protected]>
To: "Oracle" <[email protected]>
Sent: Thursday, February 13, 2003 7:03 PM
Subject: [oracle] update SQL


> Hi,
> I have one problem while executing the update statement as per my
> knowledge it should in the SQL server/ sybase but not sure about Oracle
> and its not working Can anybody can help me :
> Here is my update statement
>
>
> UPDATE PS_PAYMENT SET ADJUST = 'N', user_login_track_id = 1,
> payment_status_id = 1 FROM PS_PAYMENT PS,PS_PAYMENT_NETTED NET  WHERE
> NET.PAYMENT_ID = PS.PAYMENT_ID AND NET.PAYMENT_NETTED_ID = 4
>
>
> error is :
> ERROR at line 1:
> ORA-00933: SQL command not properly ended
>
> I will appreciate for quick reply.
>
> Thanks
> Manish
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or
> to unsubscribe send a blank email to %%email.unsub%%.


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].