Re: Oracle 8.1.7 Error

szunaj1_at_wp.pl said...
> When i'm trying to use this command
> <% rset = stmt.executeQuery("delete nazwisko, imie from test where nazwisko
> =" ('null') ""); %>
> <% while (rset.next()) %>
> i get an error about:
> java.sql.SQLException: ORA-00933:SQL Command Incorrect Ended
>
> When i'm adding new user to Oracle data base, system add also a record with
> "null" values
> I'm trying to make command to delete this records.
>
> Can somebody help me?
>
> I'm sorry for my horrible English, i'm from Poland :-).
>

I can't tell what you're trying to delete ... but the syntax of a DELETE statement is:

  delete from <table_name> where <condition(s)>

There are no column names in a DELETE.

-- 
/Karsten
DBA > retired > DBA