Re: SEQUENCE

From: Chris Kempster <c.kempster_at_cowan.edu.au>
Date: Thu, 18 Jun 1998 14:16:24 +0800
Message-ID: <6mabkg$10g$1@news.cowan.edu.au>

Try:

create table temp as

select myseq.nextval, <other columns> from <blah>

of course this is very specific and may not suit your requirements at all but its handy when generating a PK for a new table based on other tables.

vjoshi_at_pinnacle.co.uk wrote in message <6m856c$o11$1_at_nnrp1.dejanews.com>...
>Is there a way of including the next sequence number as a default value
within
>create table statement ?
>
>Many thanks in advance
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Thu Jun 18 1998 - 01:16:24 CDT