Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL/SQL*Plus: How to add numbers to rows?

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

From: Alex Jentilucci <ALEXJENT_at_prodigy.net>
Date: 1997/10/17
Message-ID: <01bcdaf8$777c2320$9788edcc@alexjent>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US