OCP 1Z0-051-105

name                            Null            Type

PROMO_ID                   NOT NULL NUMBER(3)

PROMO_NAME                               VARCHAR2(30)

PROMO_START_DATE NOT NULL DATE

PROMO_END_DATE     NOT NULL DATE

A. SELECT promo_name, NVL(NULLIF(promo_start_date, promo_end_date), 'Same Day') FROM promos;

B. SELECT promo_name, NVL(TRUNC(promo_end_date - promo_start_date), 'Same Day') FROM promos;

C. SELECT promo_name, NVL2(TO_CHAR(TRUNC(promo_end_date-promo_start_date)), NULL,'Same Day') FROM promos;

D. SELECT promo_name, DECODE((NULLIF(promo_start_date, promo_end_date)), NULL,'Same day') FROM promos;