? Conditional Statements

Conditional Statements

 Top  Previous  Next

Conditional Statements

 

DECLARE

  v_week_day VARCHAR2(30);

BEGIN

  v_week_day := TO_CHAR(SYSDATE,’DY’);

  IF (v_week_day IN (‘SAT’,’SUN’)) THEN

    DBMS_OUTPUT.PUT_LINE(‘Closed’);

ELSE

    DBMS_OUTPUT.PUT_LINE(‘Open’);

END IF;

END;

 

DEFINE VARIABLE v_week_day AS INTEGER.

v_week_day = weekday( TODAY ).

IF LOOKUP( STRING(v_week_day),"7,0") = 1 THEN

  DISPLAY "Closed".

ELSE

  DISPLAY "Open".

 

Here we define a variable v_week_day. Use standard SYSDATE (TODAY in Progress) function to get today’s date. In Oracle we convert it to character string with TO_CHAR function. In Progress it is integer day number. Then compare using IN ( LOOKUP in Progress). Finally use package DBMS_OUTPUT to print a line ( DISPLAY ).