Re: basic plsql question

From: Pedro Lopes <pedro.lopes_at_netvisao.pt>
Date: Tue, 31 Aug 2004 00:12:15 +0100
Message-ID: <newscache$ma8a3i$a67$1@newsfront4.netvisao.pt>

You can use regular expressions on 10g.

see the documentation at http://tahiti.oracle.com

bye,
pedro

jmaxsherkimer wrote:
> i had a basic question on plsql, if i have a variable as varchar2,
> containing some text like 'A12345', how do i write a function to make
> sure that the first char. is the letter 'A' or 'a' and the next five
> characters are numbers? sorry about asking a basic question, but i'm
> not the dba here, he recently left and i'm just the web developer
> having to do this for now.
Received on Mon Aug 30 2004 - 18:12:15 CDT