SQL Error: ORA-00933: SQL command not properly ended: Postgres to oracle syntax

Question

I get the SQL error ORA-00933 for the statement below. This parses in postgres, but not in oracle... How should this be formatted for oracle?

Thanks in advance!

UPDATE comments 
SET parent_type='report' 
FROM reports 
WHERE comments.parent_id=reports.id;

Please check the manual, the syntax is documented there: docs.oracle.com/cd/E11882_01/server.112/e26088/… — user330315
– user330315, Commented Feb 2, 2013 at 6:13

sgeddes · Accepted Answer · 2013-02-02 05:00:45Z

4

Try this for Oracle:

UPDATE Comments
SET parent_type = 'report'
WHERE parent_id IN (SELECT Id FROM Reports)

Or if you're trying to set the value equal to a value in another column:

UPDATE Comments
SET parent_type = (SELECT FieldName
                   FROM reports
                   WHERE reports.id = Comments.parent_id);

This would work with MSSQL:

UPDATE c
SET c.parent_type='report' 
FROM Comments c JOIN reports r ON c.parent_id=r.id

Good luck.

answered Feb 2, 2013 at 4:44

sgeddes

62.9k7 gold badges67 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1