?
Conditional Statements |
Top Previous Next |
Conditional Statements
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 ). |