SQL/SQL*Plus: How to add numbers to rows?

From: Steve Frampton <3srf_at_qlink.queensu.FOOBAR.ca>
Date: 1997/10/16
Message-ID: <6261al$b4q@knot.queensu.ca>#1/1

[From: header modified to thwart e-mail spam. See .sig for details]

I've often wondered about how to accomplish something like this using SQL or SQL*Plus:

Affiliation Employee Name

-----------   ----------------------------
AAW           1. Joe Smith
              2. Henry Lee

Teamsters     1. Ralph Johnson
              2. Norman Frank
              3. Louis Short
              4. Jane Doe

(I'm talking about the numeric entries). I've tried a myriad of things including sequences (I get a "sequence not allowed here" error), rownum (I get stupid unordered rows because I am joining a number of tables and sorting data such as affilation codes and surnames).

How to display numeric lists? I'm looking for an Oracle7 SQL or SQL*Plus solution.

Thanks in advance.

----------------< LINUX: The choice of a GNU generation. >----------------

Steve Frampton <3srf(@)qlink.queensu.ca> http://qlink.queensu.ca/~3srf ----------- Please remove .FOOBAR from address before replying. ---------- Received on Thu Oct 16 1997 - 00:00:00 CDT