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
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