Re: Help on SQL

From: Chuck <chuckh_at_softhome.net>
Date: Tue, 22 Oct 2002 14:30:58 -0400
Message-ID: <ap45h4$rjtq2$1@ID-85580.news.dfncis.de>

delete from tablename where <enter your criteria here>;

example

delete from emp where emp_no = 100;
commit;

Oracle offers a great introduction to SQL class. Have you considered attending it?

--
Chuck

"Carlos Oliveira" <carlos.a.oliveiraNOSPAM_at_vizzavi.pt> wrote in message
news:20021022190955.59186c5a.carlos.a.oliveiraNOSPAM_at_vizzavi.pt...


> Hello

>

> Please help me with this very newbie question:

> Having a table with several fields and filled with data, what SQL command

do i use to remove a row?


>

> Thank you very much in advance

>

> Carlos Oliveira

>

> -----------------------------------

> carlos.a.oliveiraNOSPAM_at_vizzavi.pt

> Remove NOSPAM for reply. Thank you.

> -----------------------------------

>

Received on Tue Oct 22 2002 - 13:30:58 CDT