Home » SQL & PL/SQL » SQL & PL/SQL » find special charecters in a column (10g)
find special charecters in a column [message #384696] Wed, 04 February 2009 21:37 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi,
I need a query to find out those records where say emp_name column is having non-alphabetic charecters like numerics, !, @#$ etc special charecters.

Thank you

Re: find special charecters in a column [message #384702 is a reply to message #384696] Wed, 04 February 2009 22:15 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.

Post DDL for tables.
Post DML for test data.

Post expected/desired results.
Re: find special charecters in a column [message #384705 is a reply to message #384702] Wed, 04 February 2009 22:31 Go to previous message
trivendra
Messages: 208
Registered: October 2007
Location: Noida, India
Senior Member
This question is asked several times in this forum, Please Look for "Regular Expressions".

Thanks
Trivnedra
Previous Topic: update statement
Next Topic: problem in date conversion (merged)
Goto Forum:
  


Current Time: Fri Dec 02 18:36:04 CST 2016

Total time taken to generate the page: 0.49237 seconds