OraFAQ Forum: Forms » getting values of some column and comparing it.

Home » Developer & Programmer » Forms » getting values of some column and comparing it. (oracle 10g, windows XP)

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

getting values of some column and comparing it. [message #469852]

Fri, 06 August 2010 02:27

myclassic
Messages: 136
Registered: December 2006
Location: Pakistan

Senior Member

Dear i have got a table having column a, b , c, d, e
and some values are stored in it. e.g. a, c and e have 'Y' and b and d have 'N' value in it.

how can i count with one query , how many columns have 'Y' and how many have 'N'.

cursor is one solution...

can anyone suggest some other solution.

waiting for responce.

regards.

Report message to a moderator

Re: getting values of some column and comparing it. [message #469857 is a reply to message #469852]

Fri, 06 August 2010 02:45

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Here it is:

SQL> select * from test;

A B C D E
- - - - -
Y N Y N N

SQL> select length(replace(str, 'N', '')) number_of_Y,
  2         length(replace(str, 'Y', '')) number_of_N
  3  from (select a||b||c||d||e str
  4        from test
  5       );

NUMBER_OF_Y NUMBER_OF_N
----------- -----------
          2           3

SQL>

Report message to a moderator

Re: getting values of some column and comparing it. [message #469871 is a reply to message #469857]

Fri, 06 August 2010 03:28

myclassic
Messages: 136
Registered: December 2006
Location: Pakistan

Senior Member

thanks dear...

this is what i wanted.

regards.

Report message to a moderator

Previous Topic:	record error
Next Topic:	Migrating from oracle 8i to oracle 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 03:23:35 CST 2025