Home » SQL & PL/SQL » SQL & PL/SQL » data filtering
data filtering [message #258617] Mon, 13 August 2007 03:43 Go to next message
arj007
Messages: 6
Registered: July 2007
Location: Bangalore
Junior Member

Hi all

Consider a column having a value 123abc ... I need only the character but not the numbers.. the o/p should be abc and this should be acheived in 9i data base.

Thanks in advance..

Regards
Arjun G
icon14.gif  Re: data filtering [message #258623 is a reply to message #258617] Mon, 13 August 2007 03:48 Go to previous messageGo to next message
sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata
Senior Member

User TRANSLATE for this.

i.e.
SELECT TRIM(TRANSLATE('123ABC123',' 1234567890',' ')) FROM DUAL;

Try this it will work.

Cheers

Sanka
Re: data filtering [message #258639 is a reply to message #258617] Mon, 13 August 2007 04:06 Go to previous message
arj007
Messages: 6
Registered: July 2007
Location: Bangalore
Junior Member

thanks dude ...
Previous Topic: bulk inserts
Next Topic: create trigger on database
Goto Forum:
  


Current Time: Sat Dec 03 18:19:25 CST 2016

Total time taken to generate the page: 0.11830 seconds