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: reset a sequence in a trigger

Re: reset a sequence in a trigger

From: Werner Hofmann <superomega_at_t-online.de>
Date: Fri, 20 May 2005 07:44:16 +0200
Message-ID: <d6jtga$3t2$1@svr7.m-online.net> 






> 1) Lookup usage for pragma autonomous_transaction at

> http://tahiti.oracle.com

> 2) What's the point of using a sequence when you are going to reset it

> everytime you insert/delete a row?

> 

> Regards

> /Rauf

> 




Hallo Rauf,



PRAGMA AUTONOMOUS_TRANSACTION;



is working fine.



Thank you,


Werner
Received on Fri May 20 2005 - 00:44:16 CDT












Original text of this message













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