Re: populating years in a drop down menu in PL/SQL

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 2 Aug 2006 14:56:12 -0400
Message-ID: <F-mdnUFAg8PSaE3ZnZ2dnUVZ_sednZ2d@comcast.com>

"Frank van Bortel" <frank.van.bortel_at_gmail.com> wrote in message news:eaqq25$fek$4_at_news3.zwoll1.ov.home.nl...
: happyardy_at_gmail.com schreef:
: > Guys,
: > I am new to PL/SQL. I am trying to have a drop down menu with years
: > from 1980-2006 etc. How do I write this? So far I have the following..
: >
:
: Make it a pipelined function (what version are you on?!?)
:
: --
: Regards,
: Frank van Bortel
:
: Top-posting is one way to shut me up...

actually, SQL is not required at all

a simple for loop for the range of years will suffice:

for thisyear v_startyear .. v_endyear
loop

/* use this year in the appropriate expression */ end loop;

++ mcs Received on Wed Aug 02 2006 - 13:56:12 CDT