OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » coulmn

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

coulmn [message #212080]

Wed, 03 January 2007 13:25

durai
Messages: 38
Registered: December 2006

Member

i created one table with column
gender char(2);
when is selected the table it shows the column gender as
ge
--
m
f
m
m
..

what shall i do to make it as gender

Report message to a moderator

Re: coulmn [message #212083 is a reply to message #212080]

Wed, 03 January 2007 13:43

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Execute the following before your SELECT:

col gender format a6

Report message to a moderator

Re: coulmn [message #212151 is a reply to message #212083]

Thu, 04 January 2007 00:51

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

Senior Member
Account Moderator

How many genders are there in your country (so that you need 2 characters, but use only F and M)? /forum/fa/1626/0/

Report message to a moderator

Re: coulmn [message #212157 is a reply to message #212151]

Thu, 04 January 2007 00:57

Frank
Messages: 7901
Registered: March 2000

Senior Member

Littlefoot wrote on Thu, 04 January 2007 07:51

How many genders are there in your country (so that you need 2 characters, but use only F and M)?

And, to add to the bad design, make it CHAR(2) instead of VARCHAR2, so you will get the pain of trailing spaces for free!

Report message to a moderator

Re: coulmn [message #212221 is a reply to message #212151]

Thu, 04 January 2007 04:59

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Littlefoot wrote on Thu, 04 January 2007 01:51

How many genders are there in your country (so that you need 2 characters, but use only F and M)?

That was my initial thought too Littlefoot. However, I was once on a project that officially recognized like 10 different genders. Can't remember what they all were, but it was surprising nonetheless.

Report message to a moderator

Re: coulmn [message #212230 is a reply to message #212221]

Thu, 04 January 2007 05:25

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

Senior Member
Account Moderator

10 different genders?!? I'd really like to see which ones they used and for what purpose! Were they human genders or ... I don't know, corn genders, goldfish genders, Alpha Centauri solar system inhabitants genders ...?

So, if you can't sleep at night, think about it and post (some of) them here. I believe this isn't necessary, but ... its urgnt plz!

Report message to a moderator

Re: coulmn [message #212234 is a reply to message #212230]

Thu, 04 January 2007 05:30

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Littlefoot wrote on Thu, 04 January 2007 12:25

We had once on a project a column 'Gender' containing something like this:
AM = Adult Male
AF = Adult Female
CM = Child Male
CF = Child Female
IM = Infant Male
...

MHE

Report message to a moderator

Re: coulmn [message #212240 is a reply to message #212230]

Thu, 04 January 2007 05:35

ebrian
Messages: 2794
Registered: April 2006

Senior Member

LOL...I'll see if I have any of the old documentation that referenced the various categories.

Report message to a moderator

Re: coulmn [message #212249 is a reply to message #212240]

Thu, 04 January 2007 06:02

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

Senior Member
Account Moderator

Please, Brian, do so. As it is urgnt.

Maarten, I don't know what was this project about, but being an "infant male" isn't really normalized. As that infant grows, its gender changes - first to child, then ... whatever follows. So, what was business rule: schedule a job which would - on daily basis - decide who isn't a child any more or who is about to die any moment or ... and update that column?

I'd, somehow, rather see their gender set to M and F (or preferred letters in someone's native tongue), while "infant" or "child" would be a matter of SYSDATE - Date_of_birth calculation.
As you can see, I have some spare time at the moment /forum/fa/1597/0/

Report message to a moderator

Re: coulmn [message #212269 is a reply to message #212249]

Thu, 04 January 2007 08:00

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Ahhh, but only if the AM/AF/CM/CF/IM/IF is connected to actual persons. It could also be it's connected to gender-specific items like clothing or something, so it wouldn't change.

But I would say from experience I can see *one* definite circumstance where additional genders would come up sometime almost certainly : When you are told in the design phase or the app that it is 100% shure that there will only be 2 genders. Wink

Report message to a moderator

Re: coulmn [message #212294 is a reply to message #212269]

Thu, 04 January 2007 09:55

durai
Messages: 38
Registered: December 2006

Member

i got the answer of this question, thanx to all for ur kind reply, actually my doubt is regarding the display of the column gender
initially when is use
select * from empgender;
ge
--
m
m
f
f

but when i made changes
col gender format a6
it works properly
select * from empgender;
gender
------
m
m
f
f

once again thanx to every body

Report message to a moderator

Previous Topic:	Neither LPAD nor RPAD - is there a middle? (merged)
Next Topic:	Execute SQL Saved in Table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 02:14:48 CDT 2024