Blog / Oracle Application Blog
Oracle SQL Query To Return Negative Numbers Within Bracket
Syntax:
to_char(-123456,’99G99G99G999PR’)
Query:
select to_char(-123456,’99G99G99G999PR’) from dual;
Output:
<1,23,456>
Related blogs
Oracle Application Blog
WIP Job Close via Apex Application
Introduction / Issue Closing a WIP job in EBS normally means going through the Discrete Jobs form manually — checking if all transactions are done, confirming t…
Oracle Application Blog
Preventing Duplicate Form Submission in Oracle APEX
Introduction / Issue One of the common issues encountered while developing Oracle APEX applications is duplicate form submission. Users may unintentionally clic…
Oracle Application Blog
UI Mistakes Oracle APEX Developers Should Avoid
Introduction / Issue Many Oracle APEX applications successfully meet business requirements but often overlook one critical aspect—the User Interface (UI) and Us…