Results 1 to 2 of 2

Thread: Hi

  1. #1
    Join Date
    Aug 2011
    Posts
    1

    Smile Unanswered: Hi

    Can anyone help me out of this query

    trunc (case when substr(APPS.OE_ORDER_LINES_ALL.ATTRIBUTE2,1,3) = 'APC' then 'APAC'
    when substr(oela.ATTRIBUTE2,1,3) = 'EMA' then 'EMEA'
    when UPPER(substr(oela.ATTRIBUTE2,1,3)) = 'MEM' then 'Americas'
    else 'UNKNOWN' END) DC_GEO

  2. #2
    Join Date
    Mar 2007
    Posts
    623
    No without knowing, what is this expression supposed to return.

    Why are you using TRUNC function on string values?
    What should be the result of e.g. TRUNC( 'UNKNOWN' ) ?

Posting Permissions

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