Use of the CASE keyword in an Oracle SQL statement

Example 1:

A) double quotation marks are required for column names that begin with "_" in the Query column.

b) Use the "case" keyword to determine whether the pass is directly based on the score.

 create  table   Tbl_score (id  number  (4 ), -- id  name" Span style= "COLOR: #0000ff" >varchar2  (30 ), --  name  score number< /span> (3 ), --  fraction  otherscore number  (3 ) --  other scores ); 

Select  as "_id",         as name,         Case            when  then            ' Passing '           Else            ' inferior lattice '       End  as  ' Pass ',       
   from Tbl_score t;

Example 2:

Returns values for different columns, depending on the situation.

Use the Tbl_score table above.

Select  as "_id",         as name,         Case            when  is NULL  Then             t.otherscore  -- can also return fixed value           else            T.score        End  as ' score '   from Tbl_score t;

Use of the CASE keyword in an Oracle SQL statement