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

Home -> Community -> Usenet -> c.d.o.server -> Sequences and group by

Sequences and group by

From: klaus1 <klaus.schu_at_gmail.com>
Date: 23 Apr 2007 22:53:42 -0700
Message-ID: <1177394022.571365.246170@c18g2000prb.googlegroups.com>


hi!

I try to use a select statement whit an myseq.nextval, but I need an group by at the end of the select.

select myseq.nextval, a, b, c from table   groupby a, b, c;

doesn't run.
anyone any idea?
thanks,
Klaus Received on Tue Apr 24 2007 - 00:53:42 CDT

Original text of this message

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