OraFAQ Forum: SQL & PL/SQL » Retrieving alpha numeric data

Home » SQL & PL/SQL » SQL & PL/SQL » Retrieving alpha numeric data (oracle 10 g)

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

Retrieving alpha numeric data [message #405564]

Thu, 28 May 2009 07:07

ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad

Senior Member

A table contains the alpha numeric data,
i want to display the student numbers
that contains alpha numeric data i.e . A114 A115 B116 C117 234A 567B
please help me
studno sname

1122 RAM
1123 SHYAM
A114 RAJ s
A115 SURI
B116 KALYAN
C117 MAHI
1125 CHARU
234A
567B

Report message to a moderator

Re: Retrieving alpha numeric data [message #405570 is a reply to message #405564]

Thu, 28 May 2009 07:23

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Tell me one thing.. Why do you post?
You don't bother to reply..
You don't bother to follow the forum guide.

By
Vamsi

Report message to a moderator

Re: Retrieving alpha numeric data [message #405587 is a reply to message #405564]

Thu, 28 May 2009 08:08

ayush_anand
Messages: 417
Registered: November 2008

Senior Member

modify it accordingly

 SELECT *
 FROM test
 WHERE REGEXP_LIKE(testcol, '[ [:digit:] ]')
 AND REGEXP_LIKE(testcol, '[ [:alpha:] ]')
/

[Updated on: Thu, 28 May 2009 08:10]

Report message to a moderator

Re: Retrieving alpha numeric data [message #405588 is a reply to message #405564]

Thu, 28 May 2009 08:10

Michel Cadot
Messages: 68734
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

From (very few of) your previous topics:

Michel Cadot wrote on Mon, 25 May 2009 06:14

Still not able to read the documentation?
Still not able to search?
Still not able to follow guidelines?

Regards
Michel

Michel Cadot wrote on Sat, 23 May 2009 08:56

I truly believe you have to think about changing your profession you surely have some skills in something but obviously not here.

Regards
Michel

Michel Cadot wrote on Tue, 26 May 2009 07:37

Still unable to follow the guidelines?
Still unable to read the documentation?
...
I strongly recommend you to change job and find something that is in your skills which is obviously not something related to computer science.

Regards
Michel

Report message to a moderator

Previous Topic:	Rownum Within Group By
Next Topic:	removing duplicate records (merged 2 )

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 12 04:54:33 CST 2025