CODEWITHSUNDEEP
sqloracle11g
Josh
Josh

Reputation: 180

Getting error ORA-00933: SQL command not properly ended

Trying to do a delete but I keep getting error "SQL command not properly ended"

script

CREATE TABLE reservation_daily_elements
( 
resort         VARCHAR2(4000 BYTE), 
room VARCHAR2(200 BYTE), 
reservation_date  VARCHAR2(200 BYTE) 
); 


INSERT INTO reservation_daily_elements (resort, room, reservation_date) 
VALUES ('210', '112', '20-JAN-2019');

query

delete room from reservation_daily_elements
where resort = '210'
and room = '112'
and reservation_date > '16-JAN-2019';

Upvotes: 0

Views: 56

Answers (2)

demircioglu
demircioglu

Reputation: 3465

Change your query to

delete from reservation_daily_elements
where resort = '210'
  and room = '112'
  and reservation_date > '16-JAN-2019';

Upvotes: 0

Zaynul Abadin Tuhin
Zaynul Abadin Tuhin

Reputation: 32001

try like below just remove room from your query

delete from reservation_daily_elements
where resort = '210'
and room = '112'
and reservation_date > '16-JAN-2019';

Upvotes: 1

Related Questions