Home » SQL & PL/SQL » SQL & PL/SQL » how to do this query pls? (merged)
how to do this query pls? (merged) [message #384445] Tue, 03 February 2009 20:55 Go to next message
dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka
Senior Member

my table structure as:

Name Gender
------- ------------
john M
Maria F
......

i want to write a query that will show the Male instead of M and Female instead of F as below:

Name Gender
------- ------------
john Male
Maria Female

can any one help me pls?


Thank you
Kamal hossain

Re: how to do this query pls? [message #384446 is a reply to message #384445] Tue, 03 February 2009 20:56 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
use DECODE() function
Re: how to do this query pls? [message #384449 is a reply to message #384446] Tue, 03 February 2009 21:04 Go to previous messageGo to next message
dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka
Senior Member

thank you very much
Re: how to do this query pls? [message #384503 is a reply to message #384449] Wed, 04 February 2009 02:30 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
or CASE
Previous Topic: Order by Clause causes slow query
Next Topic: Help me
Goto Forum:
  


Current Time: Wed Dec 07 20:22:12 CST 2016

Total time taken to generate the page: 0.18077 seconds