On Mar 20, 12:48 pm, Scott <[email protected]> wrote:
> I need a way to add a column to a query that will display output based
> on another date field and append a row counter.
> Format looks like this:
> 12/01/2008001
> 12/01/2008002
> 12/01/2008003
> 12/01/2008004
> 12/01/2008005
> 12/01/2008006
> 12/01/2008007
> 12/01/2008008
> 12/01/2008009
> 12/01/2008010
>
> etc
>
> Would I use sequence?
> Any help is appreciated, thanks.
You want to append a 'counter' to an existing date value? Does this
counter need to reset itself for each new date value? Does it need to
be assigned as each row is returned or does it need to be assigned
after the source data has been ordered?
You haven't provided enough information to make a usable suggestion.
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
