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 -> Re: SQL question, updating all rows

Re: SQL question, updating all rows

From: Mark and Karen Nolte <mknolte_at_megsinet.net>
Date: 18 Jun 1998 02:35:26 GMT
Message-ID: <01bd9a62$746b3f20$d44f85d0@mknolte> 







James Lorenzen <lorenzen_at_tiny.net> wrote in article
<lorenzen-ya02408000R1506981237520001_at_news.visi.com>...


> Create a sequence (Oracle object) and update table set newcol =


seqname.nextval


> 


> James


> 




If you need to keep adding to this table, you could use a trigger (before
insert for each row) to execute :new.newcol = seqname.nextval

Received on Wed Jun 17 1998 - 21:35:26 CDT












Original text of this message













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