PL/SQL Procedure To Display Monthly Calender

--Procedure To Display Monthly Calender

CREATE OR REPLACE PROCEDURE proc_date_disp(p_date DATE) IS

  v_first NUMBER := 0;

  v_last  NUMBER;

  v_date  DATE;

BEGIN

  SELECT To_Number(To_Char(LAST_DAY(p_date), 'dd'))

  INTO v_last FROM DUAL;

  DBMS_OUTPUT.put_line('Date           Day      ');

  DBMS_OUTPUT.put_line('------------------------');

  WHILE v_first < v_last LOOP

    v_date := TRUNC(p_date, 'mm') + v_first;

    DBMS_OUTPUT.put_line(RPAD(v_date, 15, ' ') || To_Char(v_date, 'Day'));

    v_first := v_first + 1;

  END LOOP;

END proc_date_disp;

/


Other Most Useful PLSQL Scripts:

1. PL/SQL Function To Compute The Factorial Of A Number
2. PL/SQL Function To Convert A Binary Number To A Decimal Number
3. PL/SQL Function To Convert A Decimal Number To A Binary Number
4. PL/SQL Function To Convert Ruppies(Numbers) In Words
5. PL/SQL Function To Generate The Fibonacci Series
6. PL/SQL Procedure For Counting All Tables And Respective Rows From Database
7. PL/SQL Procedure To Reverse A String
8. PL/SQL Script To Calculate Weekdays Between Two Given Dates