Category "oracle11g"

ORA 01797- operator must be followed by any or all

I am testing a condition like this in the where clause of a subquery. But I am getting the error "operator must be followed by any or all" when I execute the SS

Oracle appending string to a select statement

I have a column in a oracle table Lic_num char(7 byte) SELECT column1, 'ABC' + Lic_num FROM TABLE One I wanted ABC appended to all the rows that are returned