Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: make counter on Oracle
Look up sequence n the documentation.
Jim
-- Replace part of the email address: kennedy-down_with_spammers_at_attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "Mohammad" <mhakimjavadi_at_hotmail.com> wrote in message news:cc59b627.0305210327.5dea0fd3_at_posting.google.com...Received on Wed May 21 2003 - 08:52:41 CDT
> Hi
>
> I have problem about TRIGGER. I need to make a counter for one COLUMN
> and this starts from 1 and when the value of COLUMN change the counter
> should be start from 1 again. Do you have any idea that how can do
> that in SQL?
>
> Thanks in advance...
> Hakim