[ad_1]
UPDATE room SET price = price * 1.05
WHERE hotelNo in (SELECT hotelNo FROM hotel WHERE hotelName="Hyde Park");
0
[ad_2]
solved invalid identifier in update statement in Oracle SQL
[ad_1]
UPDATE room SET price = price * 1.05
WHERE hotelNo in (SELECT hotelNo FROM hotel WHERE hotelName="Hyde Park");
0
[ad_2]
solved invalid identifier in update statement in Oracle SQL