Re: rowid ?

From: Ed prochak <ed.prochak_at_magicinterface.com>
Date: 28 Jul 2004 10:32:03 -0700
Message-ID: <4b5394b2.0407280932.1b9a5c02@posting.google.com>

captain_2010_at_yahoo.com (captain) wrote in message news:<27aae5ab.0407272342.408a752a_at_posting.google.com>...
> hi,
>
> Want to count rowid. One row by one row
> and on each do a calculation and than go to next or previous row.
>
> In oracle it is Rowid, wonder how to do in SAS for going by row.
> e.g. in Oracle
> Select * from table1 where rowid > rowid+1
>
>
> Captain2010

NOTE: comp.databases.oracle is obsolete. this topic is appropriate for comp.databases.oracle.misc which I cross posted to with this reply.

Which do you want an answer for, ORACLE or SAS? These are two very different systems.

If you want to count rows in an ORACLE system, use the SQL command: SELECT COUNT(*) FROM table1 ;

HTH,
ed Received on Wed Jul 28 2004 - 12:32:03 CDT