home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 769 of 2,288   
   VC to bon   
   Re: case, nvl and datetime fields   
   09 Dec 03 18:23:19   
   
   From: boston103@hotmail.com   
      
   Hello,   
      
   DECODE(loandate, null, 'N', 'Y')   
      
   ..or   
      
   case when loandate is null then 'N' else 'Y'  end   
      
   Rgds.   
      
      
   "bon"  wrote in message   
   news:c7986eaf.0312091002.51327b57@posting.google.com...   
   > I have a mssql view I am translating to oracle syntax   
   >   
   > One of the lines in the mssql view is like this:   
   > DATO=CASE (isnull(loandate,1)) WHEN 1 THEN 'N' ELSE 'Y' END   
   >   
   > In other words, the view will return a Y if loandate has a value, N if   
   > it does not have a value   
   >   
   > How can I accomplish the same with Oracle9?   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca