What happens if the transaction is rolled back?

On 02/17/2004 05:03:14 PM, Juan Cachito Reyes Pacheco wrote:
> The other choice if you have to frecuently do counts to that table is
> a
> sequence
>
> You create an addiatoinal field with a sequence
>
> CREATE SEQUENCE, etc.
>
> row sequence
>
> 1     1
> 2     2
> ....
> 1234 1234
>
> Then you select from the sequence the currval, and this is immediate.
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@(protected)
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------