| Author |
SQL Script to delete the records based on length
|
sudha swami
Ranch Hand
Joined: Apr 24, 2007
Posts: 177
|
|
Hi,
I am looking for the SQL Script to delete the name whose length is less than 4 characters.
regards
sudha
|
 |
Jan Cumps
Bartender
Joined: Dec 20, 2006
Posts: 2343
|
|
mysql example (be carefull when testing!)
Regards, Jan
|
OCUP UML fundamental
ITIL foundation
|
|
sudha swami
Ranch Hand
Joined: Apr 24, 2007
Posts: 177
|
|
Hi,
I am using database as Oracle.
regards
sudha
|
|
Jeanne Boyarsky
internet detective
Marshal
Joined: May 26, 2003
Posts: 26182
|
|
Sudha,
That SQL will work in Oracle too.
|
[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
|
|
Paul Campbell
Ranch Hand
Joined: Oct 06, 2007
Posts: 338
|
|
Sudha,
Do you want to update the name to be null (remove it) where it is less than 4 or do you want to delete the row where the name is less than 4?
|
|
Jan Cumps
Bartender
Joined: Dec 20, 2006
Posts: 2343
|
|
I derived from the post's title that it was a request to delete them.
Regards, Jan
|
|
 |
|
|
subject: SQL Script to delete the records based on length
|
|
|
0
