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

Pretty easy Steve;

Here's an example:

	SELECT DISTINCT
		ROWNUM,
		TABLE_NAME
	FROM all_tables;

ROWNUM will neatly number all rows returned.

Alex

Steve Frampton <3srf_at_qlink.queensu.FOOBAR.ca> wrote in article <6261al$b4q_at_knot.queensu.ca>...
> [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.
Received on Fri Oct 17 1997 - 00:00:00 CDT