OraFAQ Forum: Training & Certification

Home » Other » Training & Certification » need sql query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

need sql query [message #268355]

Tue, 18 September 2007 05:41

oracleram
Messages: 23
Registered: November 2006

Junior Member

Hi every1,

i have empno:A123ER in table Emp,i want to retrieve only the digits 123,i need a sql query to retrive digits from alphanumeric,Thanx in advance..

Thanks & Regards,

Ram

Report message to a moderator

Re: need sql query [message #268361 is a reply to message #268355]

Tue, 18 September 2007 06:03

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

I can give you one solution. But need recursive usage of function.

Report message to a moderator

Re: need sql query [message #268362 is a reply to message #268355]

Tue, 18 September 2007 06:03

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

FAQ and definitively not an expert question.

Regards
Michel

Report message to a moderator

Re: need sql query [message #268366 is a reply to message #268355]

Tue, 18 September 2007 06:10

gauravsunil
Messages: 68
Registered: August 2007
Location: bhubaneswar

Member

select trim(trailing'E' from(trim(trailing'R' from (trim(leading'A' from 'A123ER'))))) 
from emp 
where empno='A123ER';

Regards
Sunil Gaurav

[Updated on: Tue, 18 September 2007 06:18] by Moderator

Report message to a moderator

Re: need sql query [message #268372 is a reply to message #268355]

Tue, 18 September 2007 06:18

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

select replace translate(column_name,'ABCDEFGHIJ......','                   '),' ',null) from table_name

or if you want to replace your wish
select translate(translate(column_name,'A',' '),'B',' ')..... from table_name

Report message to a moderator

Previous Topic:	Space check
Next Topic:	any sql related questions for certifications

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 04:12:56 CDT 2024