RE: Increment an alphabetic variable in a PL/SQL loop?
- From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
- To: 'Howard Latham' <howard.latham@xxxxxxxxx>
- Date: Thu, 3 Dec 2009 09:27:28 -0600
Hmmm
That might work.
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor@xxxxxxxxxxxxxxx<mailto:chris.taylor@xxxxxxxxxxxxxxx>
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.
From: Howard Latham [mailto:howard.latham@xxxxxxxxx]
Sent: Thursday, December 03, 2009 9:25 AM
To: Taylor, Chris David
Cc: Oracle-L@xxxxxxxxxxxxx
Subject: Re: Increment an alphabetic variable in a PL/SQL loop?
Couldnt you just assign using a the sql chr function
2009/12/3 Taylor, Chris David
<ChrisDavid.Taylor@xxxxxxxxxxxxxxx<mailto:ChrisDavid.Taylor@xxxxxxxxxxxxxxx>>
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@xxxxxxxxxxxxxxx<mailto:chris.taylor@xxxxxxxxxxxxxxx>
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.
--
Howard A. Latham
Other related posts:
