Help-how to creat a serious of string using PL/SQL

From: Johnson Chao <zjx110_at_my-deja.com>
Date: Fri, 18 Jun 1999 03:08:00 GMT
Message-ID: <7kcd6b$5td$1_at_nnrp1.deja.com>

Hello;
[Quoted] [Quoted]   I am encountering a very easy seemed preblem, but I am confused.

  I just want to make a function to create a serious of string like below:

A01,A02,...,A20
B01,B02,...,B20
...
H01,H02,...,H20

    My function is MFunc(x Number,y Number) return varchar2.     i.e MFunc(1,3) should return A03

           MFunc(2,4) should return B04

   How can I use For..Loop to get it?

Thanks ,very much.

--
Johnson Chao
ctc Japan


Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.

Received on Fri Jun 18 1999 - 05:08:00 CEST