Robert,
I assume it was taken out of context and modified for the sake of example.
Obviously ( or at least I hope obviously)
TO_CHAR(to_date('07/08/2010','MM/DD/YYYY'),'YYYY') is never = '1900'
and since A.flg is always either 'Y' or 'N', you could remove the WHERE
clause
entirely and it would have no effect on the result.
Mike
On Wed, Sep 1, 2010 at 2:26 PM, Rob Wolfe <wolfe....@gmail.com> wrote:
>
>
> On Sep 1, 5:23 pm, swaroop gowda <swaroop.t...@gmail.com> wrote:
> > I found an answer
> > SELECT COUNT(*) FROM TABLE_A A WHERE A.flg = CASE WHEN
> > TO_CHAR(to_date('07/08/2010','MM/DD/YYYY'),'YYYY') = '1900' THEN
> > 'Y'
> > ELSE
> > A.flg END
> > On Wed, Sep 1, 2010 at 3:59 PM, Michael Moore <michaeljmo...@gmail.com
> >wrote:
> >
> >
> >
> >
> >
> > > instead of using IN, do something like this:
> > > SELECT COUNT( * )
> > > FROM DUAL a
> > > WHERE ( TO_CHAR( TO_DATE( '07/08/1900', 'MM/DD/YYYY' ), 'YYYY' ) =
> '1900'
> > > AND a.dummy = 'X' )
> > > OR TO_CHAR( TO_DATE( '07/08/1900', 'MM/DD/YYYY' ), 'YYYY' ) !=
> '1900'
> >
> > > On Wed, Sep 1, 2010 at 1:50 PM, Michael Moore <michaeljmo...@gmail.com
> >wrote:
> >
> > >> you need an "END" for your CASE statement.
> >
> > >> On Wed, Sep 1, 2010 at 1:21 PM, swaroop gowda <swaroop.t...@gmail.com
> >wrote:
> >
> > >>> If I write a the code like this I am getting 0 count.
> >
> > >>> SELECT COUNT(*) FROM TABLE_A A WHERE A.flg IN CASE WHEN
> > >>> TO_CHAR(to_date('07/08/2010','MM/DD/YYYY'),'YYYY') = '1900' THEN
> > >>> 'Y'
> > >>> ELSE '('||''''||'Y'||''''||','||''''||'N'||''''||')'
> >
> > >>> Mainly I need when the date is 1900 then I need to select only Active
> flg
> > >>> 'Y' ELSE I need to get all data.
> >
> > >>> Please let me know Anything wrong in my statement.
> >
> > >>> --
> > >>> Thanks & Regards
> > >>> Swaroop Thailuru Swamy
> >
> > >>> --
> > >>> You received this message because you are subscribed to the Google
> > >>> Groups "Oracle PL/SQL" group.
> > >>> To post to this group, send email to Oracle-PLSQL@googlegroups.com
> > >>> To unsubscribe from this group, send email to
> > >>> oracle-plsql-unsubscr...@googlegroups.com
> > >>> For more options, visit this group at
> > >>>http://groups.google.com/group/Oracle-PLSQL?hl=en
> >
> > > --
> > > You received this message because you are subscribed to the Google
> > > Groups "Oracle PL/SQL" group.
> > > To post to this group, send email to Oracle-PLSQL@googlegroups.com
> > > To unsubscribe from this group, send email to
> > > oracle-plsql-unsubscr...@googlegroups.com
> > > For more options, visit this group at
> > >http://groups.google.com/group/Oracle-PLSQL?hl=en
> >
> > --
> > Thanks & Regards
> > Swaroop Thailuru Swamy
>
> I must be missing something because this really seems to have very
> limited utility.
>
> --
> You received this message because you are subscribed to the Google
> Groups "Oracle PL/SQL" group.
> To post to this group, send email to Oracle-PLSQL@googlegroups.com
> To unsubscribe from this group, send email to
> oracle-plsql-unsubscr...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/Oracle-PLSQL?hl=en
>
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
