Re: sub-position counter

>>Is there any reasonable way to accomplish my task?

Not knowing anything about the requirements, one approach could be:

sql> create table t1(id_n number not null, ts date default sysdate)

Tabla creada.

sql> create view t2(id_n, sub_id_n) as
  2 select id_n,
  3 row_number() over (partition by id_n order by ts) as sub_id_n
  4 from t1;

Vista creada.

sql> insert into t1(id_n) values(1);

1 fila creada.

sql> /

1 fila creada.

sql> /

1 fila creada.

sql> /

1 fila creada.

sql> /

1 fila creada.

sql> insert into t1(id_n) values(2);

1 fila creada.

sql> /

1 fila creada.

sql> /

1 fila creada.

sql> /

1 fila creada.

sql> /

1 fila creada.

sql> insert into t1(id_n) values(3);

1 fila creada.

sql> /

1 fila creada.

sql> select * from t2;

      ID_N SUB_ID_N
---------- ----------

         1          1
         1          2
         1          3
         1          4
         1          5
         2          1
         2          2
         2          3
         2          4
         2          5
         3          1
         3          2

12 filas seleccionadas.

HTH Cheers.

Carlos. Received on Wed Feb 15 2006 - 01:46:30 CST