Welcome to the Oracle Analytics Community

Home› Frank Kulash11111› Comments
Default Avatar
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Frank Kulash11111 Rank 1 - Community Starter

Comments

  • Hi, 3609739 wrote:Hi, can anyone tell me why the following Case(IF) returns and invalid expression response?CASE WHEN (CLIENT_TYPE = 'ORGTCJ' AND REGEXP_LIKE (User_name, '^[A-Z]{5}[0-9]{2}?$','i')) THEN 'ALFIE'WHEN (CLIENT_TYPE = 'ORGTCJ' AND USER_NAME IN ('AXO97', 'AAC57')) THEN 'ALFIE'WHEN (CLIENT_TYPE = 'ORGTCJ' AND…
    in Case(IF) Invalid Expression Comment by Frank Kulash11111 Dec 28, 2017 8:00AM
  • Hi, The CASE expression by itself looks okay. I'll bet the problem is how you're using the CASE expression. Show enough of the context so anybody can re-produce the problem. If you ever have a question about a SQL feature (such as CASE expressions), then you should post in in the SQL and PL/SQL Forum: By the way, the CASE…
    in Case(IF) Invalid Expression Comment by Frank Kulash11111 Dec 27, 2017 8:00AM