Breaking News: Grepper is joining You.com. Read the official announcement!

select case when oracle

Add Answer

Determined Dove answered on June 12, 2020 Popularity 10/10 Helpfulness 3/10

answer select case when oracle

related oracle case

related CASE WHEN in MS SQL or ORACLE database

select case when oracle

Comment

SELECT
	CASE COLUMN1 WHEN 'N' THEN
		CASE COLUMN2
			WHEN 1 THEN NVL(COLUMN3,COLUMN4)
			WHEN 2 THEN NVL(COLUMN3,COLUMN4) 
			WHEN 3 THEN NVL(COLUMN3,COLUMN4) 
			WHEN 4 THEN NVL(COLUMN3,COLUMN4) 
			WHEN 5 THEN NVL(COLUMN3,COLUMN4) 
			WHEN 6 THEN NVL(COLUMN3,COLUMN4)
		ELSE COLUMN5 END 
	ELSE COLUMN6 END
FROM TABLE_NAME

Popularity 10/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: oracle sql

Link to this answer
Share Copy Link

Contributed on Apr 24 2022

Determined Dove

0 Answers Avg Quality 2/10

Closely Related Answers

oracle case

Comment

SELECT product_id, product_type_id,
  CASE product_type_id
    WHEN 1 THEN 'Book'
    WHEN 2 THEN 'Video'
    WHEN 3 THEN 'DVD'
    WHEN 4 THEN 'CD'
    ELSE 'Magazine'
  END
FROM products;

Popularity 10/10 Helpfulness 5/10 Language sql

Source: www.mastertraining.com.br

Tags: case

Link to this answer
Share Copy Link

Contributed on Jun 12 2020

Tame Tortoise

0 Answers Avg Quality 2/10

CASE WHEN in MS SQL or ORACLE database

Comment

select 
  CASE WHEN Object_title in ('om','tt') THEN 'Yes'
            ELSE                 'No'
       END checkout,
  handle_class,   
  Object_title, 
  Document_highest_version_used, 
  Object_create_date, 
  Object_modified_date, 
  handle_id, 
  handle_index, 
  class_name, 
  content_Size, 
  Rendition_rendition_type
  
from 
  DSObject_tableTemp

Popularity 9/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: case-when case

Link to this answer
Share Copy Link

Contributed on Jan 12 2023

Mahesh Kumar Yadav

0 Answers Avg Quality 2/10

select case when oracle

Contents

More Related Answers

select case when oracle

Closely Related Answers

oracle case

CASE WHEN in MS SQL or ORACLE database

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.