Groups > comp.databases.oracle.misc > #814

Re: Query help

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From	Steffen Kother <steffen.kother@gmx.net>
Newsgroups	comp.databases.oracle.misc
Subject	Re: Query help
Date	Mon, 10 Mar 2014 09:12:55 +0100
Lines	21
Message-ID	<bo5ag7Fd38dU1@mid.individual.net> (permalink)
References	<bntv5hFr10uU1@mid.individual.net> <b703501e-65d3-4de3-a97c-5b8964cd9c51@googlegroups.com>
Reply-To	steffen.kother@gmx.net
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding	7bit
X-Trace	individual.net zd1YvrYe+FbtzFK6dHL8FgLYCok+1fyKLUwknLLKg6ZjY5IEVZ
Cancel-Lock	sha1:7uCoUEp8pqeeBhZeshXmQw718EU=
User-Agent	Mozilla/5.0 (Windows; U; Windows NT 6.1; de; rv:1.9.2.28) Gecko/20120306 Thunderbird/3.1.20
In-Reply-To	<b703501e-65d3-4de3-a97c-5b8964cd9c51@googlegroups.com>
Xref	csiph.com comp.databases.oracle.misc:814

Show key headers only | View raw

Hello David,

Am 07.03.2014 16:04, schrieb ddf:
> On Friday, March 7, 2014 6:16:33 AM UTC-7, Steffen Kother wrote:
>> [...]
>
> First off I'd be using lpad() instead of a case statement to format the values:

Thanks for that hint.

> What I don't  understand is you have a GROUP BY query for Access yet this is not the case for the Oracle version.  Why?  We  need a bit more information on what the result is supposed to be.

I know, want to get some results before I group them. But I didn't get 
some if I try to match SDDAT.SDKEY with GSDAT.GSPROGRP using lpad(). If 
I hard match SDKEY to '00DR' then I get some (wrong) results. I will 
check formats and also ask a tech for the database srtructure given by 
their program.

Thanks for your help.
-- 
Kind regards, Steffen

Back to comp.databases.oracle.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Query help Steffen Kother <steffen.kother@gmx.net> - 2014-03-07 14:16 +0100
  Re: Query help ddf <oratune@msn.com> - 2014-03-07 07:04 -0800
    Re: Query help Steffen Kother <steffen.kother@gmx.net> - 2014-03-10 09:12 +0100
      Re: Query help Steffen Kother <steffen.kother@gmx.net> - 2014-03-10 13:30 +0100

csiph-web