Here is the PL/SQL procedure you requested:

```sql
CREATE OR REPLACE PROCEDURE display_dates (d1 IN DATE, d2 IN DATE) IS
v_date DATE;
BEGIN
v_date := d1 + 1;
WHILE v_date

Question

Here is the PL/SQL procedure you requested:

```sql
CREATE OR REPLACE PROCEDURE display_dates (d1 IN DATE, d2 IN DATE) IS
  v_date DATE;
BEGIN
  v_date := d1 + 1;
  WHILE v_date < d2
  LOOP
    DBMS_OUTPUT.PUT_LINE(TO_CHAR(v_date, 'DD-MON-YYYY'));
    v_date := v_date + 1;
  END LOOP;
END display_dates;
/
```

This procedure starts by setting `v_date` to the day after `d1`. It then enters a loop that continues until `v_date` is not less than `d2`. Inside the loop, it uses `DBMS_OUTPUT.PUT_LINE` to print `v_date`, and then increments `v_date` by one day. The `TO_CHAR` function is used to format the date in 'DD-MON-YYYY' format.

Please note that you need to enable server output to see the result of `DBMS_OUTPUT.PUT_LINE`. You can do this by running `SET SERVEROUTPUT ON` in SQL*Plus or by configuring your SQL client accordingly.

Also, remember that this procedure does not include `d1` and `d2` in the output. If you want to include them, you should initialize `v_date` with `d1` instead of `d1 + 1`, and change the condition in the `WHILE` loop to `v_date <= d2`.

Knowee AI · Accepted Answer

Here is the PL/SQL procedure you requested:

```sql
CREATE OR REPLACE PROCEDURE display_dates (d1 IN DATE, d2 IN DATE) IS
  v_date DATE;
BEGIN
  v_date := d1 + 1;
  WHILE v_date < d2
  LOOP
    DBMS_OUTPUT.PUT_LINE(TO_CHAR(v_date, 'DD-MON-YYYY'));
    v_date := v_date + 1;
  END LOOP;
END display_dates;
/
```

This procedure starts by setting `v_date` to the day after `d1`. It then enters a loop that continues until `v_date` is not less than `d2`. Inside the loop, it uses `DBMS_OUTPUT.PUT_LINE` to print `v_date`, and then increments `v_date` by one day. The `TO_CHAR` function is used to format the date in 'DD-MON-YYYY' format.

Please note that you need to enable server output to see the result of `DBMS_OUTPUT.PUT_LINE`. You can do this by running `SET SERVEROUTPUT ON` in SQL*Plus or by configuring your SQL client accordingly.

Also, remember that this procedure does not include `d1` and `d2` in the output. If you want to include them, you should initialize `v_date` with `d1` instead of `d1 + 1`, and change the condition in the `WHILE` loop to `v_date <= d2`.

Question

Solution

Similar Questions

Upgrade your grade with Knowee