Home » SQL & PL/SQL » SQL & PL/SQL » Re: Extract numbers from a string
Re: Extract numbers from a string [message #20709] Fri, 14 June 2002 13:52
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
That is a good solution - you just have to be sure to include all of the possible non-numeric characters that could ever be stored in your string in the long string.

Otherwise, it's very easy to run into 'invalid number' errors.

Report message to a moderator

Previous Topic: Can Oracle PL/SQL call Shell Script / OS command
Next Topic: Progress of a SQL call
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 14:47:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.