Re: Increment an alphabetic variable in a PL/SQL loop?

  • From: Howard Latham <howard.latham@xxxxxxxxx>
  • To: ChrisDavid.Taylor@xxxxxxxxxxxxxxx
  • Date: Thu, 3 Dec 2009 15:24:56 +0000

Couldnt you just assign using a the sql chr function

2009/12/3 Taylor, Chris David <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
>
>
>
> *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: