OraFAQ Forum: SQL & PL/SQL » Case statement not working

Home » SQL & PL/SQL » SQL & PL/SQL » Case statement not working (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Case statement not working [message #605573]

Fri, 10 January 2014 15:03

kumaran22
Messages: 1
Registered: January 2014
Location: virginia

Junior Member

Hello,

I was wondering if there is any possibility to calculate a count on a column using a case based on two different dates. I have attached a text file with the code.

Thanks
Singaram

Attachment: error code.txt
(Size: 1.81KB, Downloaded 1246 times)

Report message to a moderator

Re: Case statement not working [message #605574 is a reply to message #605573]

Fri, 10 January 2014 15:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

see a picture of my car.
it is not working.
tell me how to make my car go.

posted SQL contains invalid syntax

since we don't have your tables or data, we can't run, test, debug or improve posted code

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Case statement not working [message #605575 is a reply to message #605573]

Fri, 10 January 2014 15:23

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Yes it is possible.

Report message to a moderator

Previous Topic:	i wanto to return One single row into column.
Next Topic:	Permutation combination

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 02:26:42 CDT 2024