[Solved] invalid identifier in update statement in Oracle SQL


UPDATE room SET price = price * 1.05
WHERE hotelNo in (SELECT hotelNo FROM hotel WHERE hotelName="Hyde Park");

0

solved invalid identifier in update statement in Oracle SQL