Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: date function

Re: date function

From: mAsterdam <mAsterdam_at_vrijdag.org>
Date: Sat, 07 Jan 2006 13:05:44 +0100
Message-ID: <43bfae2f$0$11070$e4fe514c@news.xs4all.nl>


mohitguptainfo_at_gmail.com wrote:
> hi all, i want to write a query in sql that gives me the name of the
> previous month from current date and then check that month name in
> another table 'MNTH' and then update a field 'days' in 'MNTH' table to
> an integer value (which is nothing but the number of days in that month)

Just enumerate it in the function.
The fact that your data is table shaped is not a good reason to put it in a database table. Put there what your users need to maintain. Received on Sat Jan 07 2006 - 06:05:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US