RE: Sql PLSQl

Thanks Diana

I had used your views and written a procedure which works very fine. Thanks for your Valuable suggestion

• Diana Duncan <Diana_at_fileFRENZY.com> wrote:
  > 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-----
  > Sent: Monday, October 30, 2000 5:07 PM
  > To: Multiple recipients of list ORACLE-L
  >
  >
  > 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).
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Diana Duncan
  > INET: Diana_at_fileFRENZY.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