Results 1 to 4 of 4

Thread: ENUM in Oracle

  1. #1
    Join Date
    May 2004
    Posts
    2

    Unanswered: ENUM in Oracle

    How can enumeration be achieved in Oracle eg like:-

    gender enum('male','female')

    in SQL.

    Thanks in Advance

  2. #2
    Join Date
    May 2004
    Location
    Redwood Shores, CA
    Posts
    68
    decode(gender,'male','1','female,'2',null)
    Last edited by Nocopy; 05-05-04 at 14:03.
    My way or the highway. Yeah

  3. #3
    Join Date
    May 2004
    Posts
    2
    This doesn't seem to work. Although i am using objects this may be why.

  4. #4
    Join Date
    May 2004
    Location
    Redwood Shores, CA
    Posts
    68
    Quote Originally Posted by monty10
    This doesn't seem to work. Although i am using objects this may be why.
    How do you think objects make difference?

    Post code fragment.
    My way or the highway. Yeah

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •