Something like this???
DECLARE
--x VARCHAR2 (128) := 'abcdefg';
x VARCHAR2 (128) := 'abcdefg123';
BEGIN
DBMS_OUTPUT.ENABLE (1000000);
IF SUBSTR (x, LENGTH (x) - 1, 1) IN
('1', '2', '3', '4', '5', '6', '7', '8',
'9', '0')
THEN
DBMS_OUTPUT.put_line ('Ends in a number... ');
ELSE
DBMS_OUTPUT.put_line ('Ends in a letter... ');
END IF;
END;
-----Original Message-----
Sent: Friday, October 25, 2002 3:39 PM
To: Multiple recipients of list ORACLE-L
Is there any way to do pattern matching in a PL/SQL trigger? In other
words,
if I had two strings and one ended with a character (ie. "g") and one ended
with a number, is there a way to search for it so that it would flag if it
is
only a number?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mike Sardin
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mirsky, Greg
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
