Search Result

I have a SQL statement that performs correctly using MS Sql (all versions), but as I'm attempting to convert it Oracle 11g, I'm having some issue where the return result says that the command is not properly ended. Yet, the subquery seems to operate correctly if I remove the update parameters.

What this sql is supposed to do is select the first 50 rows, then update each of the selected rows with specific values.

Original...

Hi I am trying to update my table using this..

update tablename set sqlquery = 'select max(upd_rows) from tablename
where data_center='** *' and tab_abbrev='*** '' where userid='12345';

But am getting this error
ORA-00933:SQL command not properly ended

I dunno how to fix it.can anyone please help me out???

Thanks