RE: Sql PLSQl

From: Diana Duncan <Diana_at_fileFRENZY.com>
Date: Mon, 30 Oct 2000 18:02:35 -0500
Message-Id: <10665.120624@fatcity.com>

The query below should at least get you started:

select trunc(trunc(my_date) - to_date('01-OCT-2000'), -1), count(*) from my_table
where my_date between to_date('01-OCT-2000', 'DD-MON-YYYY')

and to_date('31-OCT-2000', 'DD-MON-YYYY') group by trunc(trunc(my_date) - to_date('01-OCT-2000'), -1) /

It should be very easy to use that as a cursor and print out the results you desire.

HTH,
Diana

-----Original Message-----
From: Navtej B [mailto:navtej_b_at_yahoo.com] Sent: Monday, October 30, 2000 5:07 PM
To: Multiple recipients of list ORACLE-L Subject: Sql PLSQl

Hi Plsql Guru

I had a problem and really appreiate for coding help

I had table that contains sevral thousands records with Date field. What I want is that if I will supply start and End date to the Procedure, it should give me the Output of number of records in between the Start and End date and the output should comes out in terms of ten days interval

e.g. I had given 1st October to 30October , then the output as

1-10October ---> 300
11-20October --> 190
20-30October --> 400

Thanks for Help in Advance
NvatejBir

Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Navtej B
INET: navtej_b_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Oct 30 2000 - 17:02:35 CST