Hi Scott, i´m a GoogleGropus-beginner but i hope you´ll find that useful.
For a gapless cycle of numbers i would use the pseudocolumn "rownum". example : select rownum, * from dummytable convert it to char and fill the missing leading "0" with lpad like this: select lpad(to_char(rownum),3,'0'), * from dummytable concat the cycle using the pipe like that: select to_char(sysdate,'dd\mm\yyyy') || lpad(to_char(rownum),3,'0') from dummytable hope that helps Martin On 20 Mrz., 18:48, 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 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 -~----------~----~----~----~------~----~------~--~---
