Monday, December 21, 2020

 DECLARE

      n_maxlen  number := 30;

    BEGIN

      for i in 1..n_maxlen - length(to_char(sysdate,'mm/dd/yyyy')) + 1

      loop

        DBMS_OUTPUT.PUT_LINE('The date is: ' || lpad(rpad(to_char(sysdate,'mm/dd/yyyy'),n_maxlen-i+1,'*'),30,'*'));

      end loop;

    END;

/

The date is: 12/17/2020********************
The date is: *12/17/2020*******************
The date is: **12/17/2020******************
The date is: ***12/17/2020*****************
The date is: ****12/17/2020****************
The date is: *****12/17/2020***************
The date is: ******12/17/2020**************
The date is: *******12/17/2020*************
The date is: ********12/17/2020************
The date is: *********12/17/2020***********
The date is: **********12/17/2020**********
The date is: ***********12/17/2020*********
The date is: ************12/17/2020********
The date is: *************12/17/2020*******
The date is: **************12/17/2020******
The date is: ***************12/17/2020*****
The date is: ****************12/17/2020****
The date is: *****************12/17/2020***
The date is: ******************12/17/2020**
The date is: *******************12/17/2020*
The date is: ********************12/17/2020

PL/SQL procedure successfully completed.




No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...