search for a number in a string?
From: Geetha <gelangov_at_hotmail.com>
Date: 19 Apr 2003 05:48:16 -0700
Message-ID: <4b40e20a.0304190448.107c5537_at_posting.google.com>
...
Date: 19 Apr 2003 05:48:16 -0700
Message-ID: <4b40e20a.0304190448.107c5537_at_posting.google.com>
In oracle, is there a way to search for a number in a string?
For example, in SQL server we can do:
select * from sysobjects where name like 'df_arc%[0-9]':
DF_Arc__1 DF_Arc__10 DF_Arc__11 DF_Arc__12 DF_Arc__13 DF_Arc__14 DF_Arc__15 DF_Arc__16 DF_Arc__17
...
Thank you very much for your help in advance! Received on Sat Apr 19 2003 - 14:48:16 CEST