Re: extending SQL

Create table padding (n number);
insert into padding values (1);
insert into padding values (2);

    ....
etc. to whatever limit.

select

   name, total,n
from

    companies,
    padding
where

    n <= total
;

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

CL wrote in message <4Mxc3.1062$Dl.30497_at_news.clear.net.nz>...
>Hi there
>
>I have a case need to extend a table like this
>name total
>cmpA 4
>cmpB 3
>
>into the table like this
>
>name total sn
>cmpA 4 1
>cmpA 4 2
>cmpA 4 3
>cmpA 4 4
>cmpA 3 1
>cmpA 3 2
>cmpA 3 3
>
>Can any noe help? thanks in advance.
>
>Charles
>
>
>
>
Received on Thu Jun 24 1999 - 17:22:05 CDT