Re: Help for SQL!?

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sat, 03 Jul 2004 17:53:30 -0700
Message-ID: <1088902443.769543@yasure>

JZ wrote:

> Our JAVA code only can process SQL, not PL/SQL. I know if PL/SQL can
> be used, the problem is pretty easy to solve.
> 
> 
> Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1088834737.754221_at_yasure>...
> 

>>JZ wrote:
>>
>>
>>>Oracle 9.2
>>>
>>>I have a table like:
>>>
>>>t1 t2 t3
>>>-----------------------------
>>>char1 01/01/2004 01/05/2004
>>>char1 01/10/2004 01/15/2004
>>>char1 01/20/2004 01/25/2004
>>>char1 01/01/2004 01/15/2004
>>>char1 01/01/2004 01/25/2004
>>>char1 01/10/2004 01/25/2004
>>>
>>>t2 value is always less than t3.
>>>
>>>How can I use SQL (no PL/SQL) to get output like:
>>>
>>>t1 t2 t3
>>>-----------------------------
>>>char1 01/01/2004 01/05/2004
>>>char1 01/10/2004 01/15/2004
>>>char1 01/20/2004 01/25/2004
>>>
>>>WHat I want is: no 'middle' values between t2 and t3 can be found in
>>>the table.
>>>The reason why 'char1 01/01/2004 01/15/2004' is no good is because
>>>'01/10/2004' is between '01/01/2004' and '01/15/2004', and it's in the
>>>table.
>>>
>>>Any help?
>>>
>>>THanks a lot!!!
>>
>>This is school work so you need to work on this yourself.
>>
>>Personally I think the request preposterous and that any sane person
>>would use PL/SQL.

Java can submit PL/SQL in the form of anonymous blocks. But given that you didn't know that my guess is that your knowledge of Oracle is so limited that you shouldn't be writing any.

Get someone that knows how to write stored procedures to write the code and pass parameters to the procedure.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Sat Jul 03 2004 - 19:53:30 CDT