Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Counting number of rows, sequences
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
Then you select from the sequence the currval, and this is immediate.
![]() |
![]() |