ORA-00933:SQL command not properly ended

[narenshines]

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

[debasisdas]

What are you trying do ? are you storing a sql query in a table ?

Please clairfy.

[amitpatel66]

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

Try this:

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

[ajmca]

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

you have specified WHERE twice. try:

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

Also keep in mind yo are returning a number from this select statement. What is the datatype of sqlquery?

[subashsavji]

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

USE THIS

UPDATE EMP SET ENAME = 'select max(SUBSTR(JOB,1,2)) from EMP
where EMPNO=' || '7839' || 'and DEPTNO=''10' 'and userid='||'12345'
/

OR USE THIS FOR UPDATION INSTEAD OF DELETE

CREATE OR REPLACE PROCEDURE delete_all_rows
(p_tab_name IN VARCHAR2, p_rows_del OUT NUMBER)
IS
cursor_name INTEGER;
BEGIN
cursor_name := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(cursor_name, 'DELETE FROM '||p_tab_name,
DBMS_SQL.NATIVE );
p_rows_del := DBMS_SQL.EXECUTE (cursor_name);
DBMS_SQL.CLOSE_CURSOR(cursor_name);
END;
/

VARIABLE deleted NUMBER
EXECUTE delete_all_rows('employees', :deleted)
PRINT deleted