forum.lissyara.su

delete 
  from custemp c
 where c.date between to_date('01.01.2000', 'dd.mm.yyyy') and
       to_date('01.03.2010', 'dd.mm.yyyy')
       and rownum <= 10000
 order by c.date

DELETE Statement

If you’re getting the “ORA-00933 sql command not properly ended” on DELETE, then your query might look like this:

The error appears because the ORDER BY does not belong in a DELETE statement. The ORDER BY is only for ordering data returned by a SELECT statement, and serves no purpose in a DELETE statement.

So, change your query to remove the ORDER BY clause:

Neus писал(а): ↑

2023-06-23 22:08:58

Он же тебе написал в чем ты балбес и что надо сделать: "So, change your query to remove the ORDER BY clause"

Error report -

SQL Error: ORA-00933: неверное завершение SQL-предложения

00933. 00000 - "SQL command not properly ended"

*Cause:

*Action: