This is not new but I’ve learned about it last week 🙂 from one of developers when reviewing codes with them for the plan to change the sequence’s current value. Normally I would drop the sequence and create it with START WITH to a new desired number. However, my approach will obviously invalidate all dependencies …
Change sequence’s current value (CURRVAL) without dropping it Read More »
If the Developer Toolbar (shown below) in your Oracle APEX application is not displayed, you can control its display by changing the Status attribute on the application’s Edit Definition page. I’ve learned about this when somehow one of our applications suddenly did not display the Developer Toolbar. We found out later that during environment refresh, …
The Developer Toolbar in APEX Application Disappeared Read More »
Quick bullet points from reading the Transparent Performance Improvement: Real Native Compilation from the PL/SQL Enhancements in Oracle Database 11g white paper: The PL/SQL is an interpreted language but it is not just like other interpreted languages , e.g. BASIC, where the code is processed statement by statement at the run time. The PL/SQL code …
We’re working on the installation scripts for an internal PL/SQL applications. Multiple scripts are called from the main one. To capture errors from script execution, normally the spool syntax will be used in the scripts to pipe out all executions into log files, and then later the deployment team members will examine them using find/search …
In APEX 4, we now have the option to place where the uploaded file will be stored within the development workspace interface. The Storage Type setting of the File Browser item has two options: Table WWV_FLOW_FILES stores the uploaded file in the table wwv_flow_files (or APEX_APPLICATION_FILES). This is the default way in the previous versions …
File Browser in APEX 4 with BLOB column specified in item source attribute Read More »
I must admit that I’ve rarely done database export from a higher version and import into a lower one. Most of the time it will be either same version (between production, UAT, test or development), or to a higher one in the upgrade scenario. I got an import error ORA-39142: incompatible version number when attempting to …
Import Data Pump ORA-39142: incompatible version number Read More »
