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

plsql case expression

Add Answer

R Dyk answered on July 12, 2021 Popularity 8/10 Helpfulness 2/10

answer plsql case expression

related pl sql case

related plsql case expression

plsql case expression

Comment

CREATE OR REPLACE FUNCTION plch_start_date (
   frequency_in   IN VARCHAR2,
   date_in        IN DATE DEFAULT SYSDATE)
   RETURN VARCHAR2
IS
BEGIN
   RETURN TO_CHAR (
             ADD_MONTHS (
                date_in,
                CASE frequency_in
                   WHEN 'Y' THEN -12
                   WHEN 'Q' THEN -3
                   WHEN 'M' THEN -1
                END),
             'YYYY-MM-DD');
END;
/

Popularity 8/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: case-expression plsql sql

Link to this answer
Share Copy Link

Contributed on Mar 19 2023

R Dyk

0 Answers Avg Quality 2/10

Closely Related Answers

pl sql case

Comment

CASE [ expression ]

   WHEN condition_1 THEN result_1
   WHEN condition_2 THEN result_2
   ...
   WHEN condition_n THEN result_n

   ELSE result

END

Popularity 10/10 Helpfulness 4/10 Language sql

Source: www.techonthenet.com

Tags: case

Link to this answer
Share Copy Link

Contributed on Jul 12 2021

Open Octopus

0 Answers Avg Quality 2/10

plsql case expression

Comment

gender_name := CASE gender_code
				WHEN 'M' THEN 'MALE'
                WHEN 'F' THEN 'FEMALE'
                ELSE 'UNKNOWN'
               END;

Popularity 8/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: case-expression

Link to this answer
Share Copy Link

Contributed on Mar 19 2023

R Dyk

0 Answers Avg Quality 2/10

plsql case expression

Contents

More Related Answers

plsql case expression

Closely Related Answers

pl sql case

plsql case expression

Grepper

Documentation

Social

Legal

Contact

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