I don't understand the question. You say "prints out all of the columns" yes your input data only consists of one string column. Also, one thing you are going to have to do is to ORDER your data. Without an ORDER BY, you have no way of knowing what will come before what.
Mike On Tue, May 12, 2009 at 2:57 PM, oracle <mrsmi...@gmail.com> wrote: > > My data looks like this > > > 8-8-19-66-1-2-22 > 8-8-19-66-1-2-30 > 8-8-19-66-1-2-0 > 8-8-19-65-0-0-0 > 8-8-19-65-1-2-28 > 8-8-19-65-2-5-21 > > > I am trying to create a query that trys to find the first solo 0 > between the "-" and then prints out all of the columns that have the > same values up to the solo 0. > > I have something, but it is not quite right. > > select distinct territory ,SUBSTR(territory, 0,INSTR(territory,'-0', > 1, 1)-1) as s > from eligibility_revenue where fiscal_qtr_nbr=3 and > SUBSTR(territory, 0,INSTR(territory,'-0', 1, 1)-1) like > SUBSTR('8-8-19-66-1-2-0', 0,INSTR('8-8-19-66-1-2-0','-0', 1, 1)-1) > > I want this query to produce: > 8-8-19-66-1-2-22 8-8-19-66-1-2 > 8-8-19-66-1-2-30 8-8-19-66-1-2 > 8-8-19-66-1-2-0 8-8-19-66-1-2 > > The territory will be passed to the query. In this case: > 8-8-19-66-1-2-0. The first solo 0 is at the end, so we should create a > query that has a like clause that looks for '8-8-19-66-1-2-' That's > where I am struggling and any help would be great. > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---