Correct. One column. The second column is just the first column with
everything from the column until it sees the "-0" Maybe just doing this
pragmatically would be easier.
On Tue, May 12, 2009 at 6:28 PM, Michael Moore <michaeljmo...@gmail.com>wrote:
> yes = yet
>
>
> On Tue, May 12, 2009 at 4:28 PM, Michael Moore <michaeljmo...@gmail.com>wrote:
>
>> 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.
>>>
>>>
>>>
>>
>
> >
>
--
Anthony Smith
"Having education and talent doesn't make you better than the world... it
makes you responsible for it!"
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
