Re: first row of database

If you are using Oracle 8.i or greater, you can do:

   select * from yourTable
   where  rownum < 2



JW

--- Robbie Staufer <rstaufer@scd.ucar.edu> wrote:
> Hi,
> 
> Is there a way to refer to the first row of a database (row 0?) ?
> 
> For example, the first row of my database contains header information.
> I want the header row to print out first whenever data is requested, so
> the output file looks like this:
> 
> header,  header, header, header, header
> data, data, data, data, data,
> data, data, data, date, data
> 
> I know how to print out the data, but can't figure out how to ask for
> the first row.
> 
> Many thanks,
> Robbie
> 
> --
> -*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
> Robbie Staufer
> NCAR/SCD
> 1850 Table Mesa Dr. Rm. 42
> Boulder, CO. 80305
> (303) 497-1836
> 
> 
> 
> -- 
> To unsubscribe, e-mail: beginners-unsubscribe@perl.org
> For additional commands, e-mail: beginners-help@perl.org
> 


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

• first row of database by Robbie Staufer
• RE: first row of database by Bob Showalter
• Re: first row of database by Jeff Westman