Re: Delete a row

parcha_at_gmail.com wrote:
> I have a table with two columns 'id'(VARCHAR2) and CLOB
>
> Can someone tell me how can I write a SQL Query to delete a row from
> the table if the CLOB data is null or empty?
>
> Thanks.

If you have a column named ID ... rename it.

SELECT keyword FROM v_$reserved_words;

But to answer your question.

DELETE FROM t
WHERE id = <some_value>;

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)