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_at_newsfront4.netvisao.pt>
Date: Tue, 31 Aug 2004 00:12:15 +0100
Message-ID: <newscache$ma8a3i$a67$1_at_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 Tue Aug 31 2004 - 01:12:15 CEST