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;
/
Md. Quium Hossain who I'm Oracle DBA & APEX Developer. All-rounder in building small, medium, and enterprise applications. Extensive knowledge in various areas of web-driven applications in Back-end (PL/SQL, SQL, Java), Front-end (Oracle APEX, Oracle Forms, Oracle Reports, HTML, JavaScript, CSS, jQuery, OracleJET, ReactJS), RESTful APIs, Third-party library integrations (Apex Office Print (AOP), Payment Gateways, SMS, Syncfusion, HighCharts) and APEX Plugins (HighChart, StarRating)
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;
/
#########################Install Oracle APEX 24.1################################ ----------------------------------------------------...
No comments:
Post a Comment