basic plsql question
From: jmaxsherkimer <jmaxsherkimer_at_hotmail.com>
Date: 27 Aug 2004 05:20:36 -0700
Message-ID: <f8606b97.0408270420.167b32fb_at_posting.google.com>
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 Fri Aug 27 2004 - 14:20:36 CEST
Date: 27 Aug 2004 05:20:36 -0700
Message-ID: <f8606b97.0408270420.167b32fb_at_posting.google.com>
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 Fri Aug 27 2004 - 14:20:36 CEST