Home » SQL & PL/SQL » SQL & PL/SQL » delete clause
delete clause [message #205045] Thu, 23 November 2006 02:41 Go to next message
ashish_pass1
Messages: 114
Registered: August 2006
Location: delhi
Senior Member
hello everyone

i unable to delete those 5 rows which does not contain any data.
can u plz help me to solve this problem.


ashish>select * from magazines;

TITLE
---------------------------------------------
THE BARBERS WHO SHAVE THEMSELVES.
"HUNTING THOREAU IN NEW HAMPSHIRE"
THE ETHNIC NEIGHBORHOOD
RELATIONAL DESIGN AND ENTHALPHY
"INTERCONTINENTAL RELARIONS"






10 rows selected.



with regards
ashish
Re: delete clause [message #205047 is a reply to message #205045] Thu, 23 November 2006 02:44 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi ashish

delete table_name where column_name IS NULL



HTH
Taj
Re: delete clause [message #205051 is a reply to message #205047] Thu, 23 November 2006 02:47 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Or (as the column might have spaces in it)
DELETE magazines
WHERE trim(title) is null;
Re: delete clause [message #205053 is a reply to message #205045] Thu, 23 November 2006 02:49 Go to previous message
ashish_pass1
Messages: 114
Registered: August 2006
Location: delhi
Senior Member
thanxx to u all

with regards
ashish
Previous Topic: filling up missing records query
Next Topic: how to code this in PLSQL(dynamic) (merged 3 cross-posts)
Goto Forum:
  


Current Time: Sun Dec 11 02:17:04 CST 2016

Total time taken to generate the page: 0.07467 seconds