Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Counting number of rows, sequences
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_at_freelists.org
> 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
> -----------------------------------------------------------------
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Feb 17 2004 - 16:13:09 CST
![]() |
![]() |