RE: Increment an alphabetic variable in a PL/SQL loop?
Date: Thu, 3 Dec 2009 10:46:02 -0500
Message-ID: <003501ca742f$b840f470$28c2dd50$_at_com>
I've seen a lot of good answers but I have to ask, Why do you need this? What is the business need that requires an incremental letter versus a number?
Chris
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Taylor, Chris David
Sent: Thursday, December 03, 2009 10:21 AM
To: 'Oracle-L_at_freelists.org'
Subject: Increment an alphabetic variable in a PL/SQL loop?
Hey how can we increment an alphabetic variable in PL/SQL?
Let's say I have var1 = 'A' for the first pass, but for the second pass, I want it to autoincrement to var1='B' and ultimately to 'Z'.
I'm searching but its hard to find the right search terms to give me what I want.
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor_at_ingrambarge.com
CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 03 2009 - 09:46:02 CST