PL/SQL CASE Statement

Posted on 2009-05-05
Medium Priority
Last Modified: 2013-12-07
I keep getting errors on this.  Can someone help me write this statement correctly?  
Basically, if my first result ends in "0", then I want the first letter of the last name, else I want the last number of the Subscriber ID.

CASE substr(O221762."Subscriber_ID",9,1)
     WHEN "0" THEN  substr(O221762."Mbr_Last_Name",1,1) AS "CM_ID"
     ELSE substr(O221762."Subscriber_ID",9,1) AS "CM_ID"

Open in new window

Question by:Luis5011
  • 2
LVL 14

Expert Comment

ID: 24306765
How abt this?

 CASE substr(O221762.Subscriber_ID,9,1)
     WHEN '0' THEN  substr(O221762.Mbr_Last_Name,1,1) AS "CM_ID"
     ELSE substr(O221762.Subscriber_ID,9,1) AS "CM_ID"

Open in new window


Author Comment

ID: 24306962
Nope.  Tells me I have a missing key word.

Accepted Solution

Luis5011 earned 0 total points
ID: 24307115
I figured it out.  I used the following format and added the " " around the field name, which I hadn't done.

     WHEN substr(O221762."Subscriber_ID",9,1)= 0 THEN  substr(O221762."Mbr_Last_Name",1,1)
     WHEN substr(O221762."Subscriber_ID",9,1)<>0 THEN  substr(O221762."Subscriber_ID",9,1)

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question