Monday, January 1, 2024

Date Format in ifs

 DECLARE

    a_ VARCHAR2(32000) := NULL;

    default_date_ DATE := TO_DATE('&FROM_DATE', 'YYYY-MM-DD-HH24-MI-SS');  -- Assuming &FROM_DATE is a date

    extracted_dd VARCHAR2(2) := TO_NUMBER(TO_CHAR(default_date_, 'DD'));

BEGIN

    dbms_output.put_line(extracted_dd);

END;



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...