Home » SQL & PL/SQL » SQL & PL/SQL » search spaces in column (oracle 9i)
search spaces in column [message #447477] Mon, 15 March 2010 07:29 Go to next message
vivek_rol
Messages: 65
Registered: February 2009
Member
in my databse i have column name as email_id

in this column email id of cutomers are stored
but in some emaild contains space

i want to find out such email id
Re: search spaces in column [message #447480 is a reply to message #447477] Mon, 15 March 2010 07:35 Go to previous messageGo to next message
Michel Cadot
Messages: 63818
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
where instr(mycol, ' ') > 0

Regards
Michel
Re: search spaces in column [message #447487 is a reply to message #447480] Mon, 15 March 2010 07:43 Go to previous messageGo to next message
vivek_rol
Messages: 65
Registered: February 2009
Member
thanks michel
Re: search spaces in column [message #447528 is a reply to message #447487] Mon, 15 March 2010 13:34 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
There are quite a few solutions for more extensive checking. See http://forums.oracle.com/forums/thread.jspa?messageID=1323440&#1323440
Previous Topic: Rank
Next Topic: sql to alter
Goto Forum:
  


Current Time: Sat Oct 01 04:09:31 CDT 2016

Total time taken to generate the page: 0.09897 seconds