Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2012
    Posts
    1

    Smile Unanswered: Exists inside Decode function

    I have to display values from two tables. tableA having 'ID' and 'name' columns and tableB having 'name'. If ID exists in tableA I have to display tableA 'name' otherwise have to display tableB 'name'

    I tried the below one but it is not working
    decode(tableA.id, 'EXISTS' , tableA.name, tableB.name)

    Please help me on this.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    when all else fails Read The Fine Manual

    DECODE
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Tags for this Thread

Posting Permissions

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