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

Home -> Community -> Usenet -> c.d.o.server -> Re: calc field

Re: calc field

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Tue, 30 Sep 2003 22:14:59 GMT
Message-ID: <3F7A0063.3CB37F90@remove_spam.peasland.com>


Again, look at the CASE statement. Have it check the year and then use the appropriate TO_DATE function with the appropriate format mask. If you are not using 9i, then let us know and a different solution can be found.

HTH,
Brian

Roger Smith wrote:
>
> Last question
>
> to_date(concat(nvl(SomeYear, 1990), '/01/01'),'YYYY/MM/DD')
>
> This works fine as long as SomeYear is 4 digits....any way to trap 2 digits?
>
> Roger
>
> "Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message
> news:3F79EF49.DFB4F3B_at_remove_spam.peasland.com...
> > You nested NVL functions, or DECODES, or we didn't even show you 9i's
> > new CASE statement.......
> >
> > Cheers,
> > Brian
> >
> > Roger Smith wrote:
> > >
> > > IF both are null, can I set a default?
> > >
> > > "Michel Cadot" <micadot2removethat_at_free.fr> wrote in message
> > > news:3f79e71d$0$10410$626a54ce_at_news.free.fr...
> > > >
> > > > "Roger Smith" <rsmith22_at_fastmail.net> a écrit dans le message de
> > > > news:4ileb.35770$H86.839814_at_news1.telusplanet.net...
> > > > > Need suggestions on how to accomplish this, I know you can create a
> > > > > calculated field in sql:
> > > > >
> > > > > select (productPrice * 1.5) as "NewPrice"
> > > > >
> > > > > but my calc field is complicated by if then, if productPrice not
> null
> > > then
> > > > >
> > > > > select (productPrice * 1.5) as "NewPrice" else
> > > > >
> > > > > select (WarehousePrice * 1.5) as "NewPrice"
> > > > >
> > > > > and so on... can this be done in sql?
> > > > >
> > > > > Roger
> > > > >
> > > > >
> > > >
> > > > Use the NVL function:
> > > > select nvl(productPrice,WarehousePrice)*1.5 as "NewPrice" ...
> > > >
> > > > Hope this helps
> > > > Michel Cadot
> > > >
> > > >
> >
> > --
> > ===================================================================
> >
> > Brian Peasland
> > dba_at_remove_spam.peasland.com
> >
> > Remove the "remove_spam." from the email address to email me.
> >
> >
> > "I can give it to you cheap, quick, and good. Now pick two out of
> > the three"

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"
Received on Tue Sep 30 2003 - 17:14:59 CDT

Original text of this message

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