Using Arrays in PL/SQL

code_lover · March 16th, 2007, 01:48 PM

How do we use arrays in PL/SQL?How to print this pattern.?
A1,A2,A3,A4,A5,A6,A7,A8,A...

B1,B2,B3,B4,B5,B6,B7,B8,B...
.
.
.
Z1,Z2,Z3,Z4,Z5,Z6,Z7,Z8,Z...

MAXOOD!

Life is an endless journey towards perfection

peace95 · March 16th, 2007, 02:11 PM

code_lover:
It is difficult to respond to your question with very little information: How are the items A1.... B1..... .....Z1 listed in your Oracle database? Are the items in separate Tables or the same Table? Are they the same Data Type? Is there a Database Relationship between them? Or are you trying to establish a DB Relationship between the items? Please explain in detail what you are attempting to do?

========================
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.

code_lover · March 17th, 2007, 09:32 AM

My question has nothing to do with database.The values shown in the above pattern are hard-coded values.And they will be stored in arrays.Now i want to know how can i print this pattern using a FOR loop.

MAXOOD!

Life is an endless journey towards perfection