One of the most popular places to store and share your code online is GitHub. And one of the best free desktop Version control tools is without any doubt Sourcetree. Having all the good feature, of using them both, in mind, there are still some moments that can ruin your experience, especially when you are … Continue reading Link Sourcetree to your GitHub account
It happens that you forget your master ADMIN password for the apex_admin page. Here are the two widely user methods to change it and unlock the Admin account: Use @apxchpwd.sql script in your APEX directory. To run it, navigate to the directory through bash or Command prompt. Connect to your database as SYS and run … Continue reading Unlock APEX Admin account
It happens relatively rarely to have an error PLS-00907 (PLS-00907: Can not load library unit). We have encountered it few times in our APEX applications. Here is the way to resolve it (performed by a SYS user). Solution : Ask your DB admin to flush the shared pool 🙂
By default, if you use embedded PL/SQL gateway to run your APEX, PDF printing is not possible. There are several ways to make it possible. By configuring ORDS and running it in either Standalone mode or into Apache Tomcat / Glassfish / or other web server. This option is completely free and easy to setup. … Continue reading Print PDF reports with APEX 5.1 + ORDS
Oracle MIN() Over function has an interesting options. It can be used to get the MIN value from a particular subset of data, or show he MIN value, based on the records ranked so far, if it is used with ORDER BY clause. Here is an example: 1 select ename, 2 deptno, 3 sal, 4 … Continue reading Oracle MIN() OVER function
Listagg is a great way to concatenate strings in Oracle 12. I have used it in many cases, but sometimes it is just not good enough for a very large strings. Here is the way you can use it for strings, that would not exceed 4000 chars: SELECT FNR, ATTEST_DATO, STATUS, TYPE_FORMAAL, LISTAGG(INNHOLD, CHR(13)||CHR(10) ) … Continue reading Oracle 12.1, ORA-01489 result of string concatenation is too long
This is a bug in Oracle 12.1. When you have a table in one schema (Schema1) with a sequence on some column and you want to insert in that table from another schema (Schema2), error message "ORA-00942: table or view does not exist" is displayed. This happens although you have privileges to select, insert, update … Continue reading Oracle 12.1, ORA-00942: table or view does not exist
APEX App Lab - Blog 