man : display Manual of commands ls : listing folder structures cd: navigate folder structures Head,tail : peek content of a file (default 10 lines) cat: concate files, display content of a file (full) Sort: sort output lines (numerica or alphabic) less: display file content with pagination | : piping standard input to the next…
Read more
Docker learning notes
How to fix docker: Got permission denied while trying to connect to the Docker daemon socket. Read more here. Images Container Tab into a running container’s cli Start a status ‘exited’ container and tab into the bash start a container with port mapping Create a new image with a running container where configuration are made…
Read more
Migrate APEX to Autonomous Database with custom ORDS (notes)
Create And Manage Your Custom ORDs
Read morePLSQL XMLTABLE examples
sample xml
Read more
Ubuntu 20.04 x86 openVPN
Enable Root Enable root login over SSH add line Save and exit the file Install VPN and Configure it download this script, make sure you ssh logged in as root Enable password authentication, find the lines of creating SSL certificate in the script and remove “nopass” Use nano to open the .sh file and remove…
Read morePWA in Oracle APEX
Serve your application with offline content Web Push notifications Sync to handle offline User DML request( REST API only) Serve your application with offline content when network is down. Serve server rendered html when network is up. serve your application with offline caches via Fetch event ( fetch event fires each time a request is…
Read more
Protected: Get my Dutch together../. [26-Aug-2022]
There is no excerpt because this is a protected post.
Read more
Oracle APEX Interactive GRID with customised buttons on the tool bar
The goal is to have a custom button on the IG toolbar but doing something other than the regular functions provided by IG, in my example I am trying to achieve two things open dialog (via a button) execute some custom JS codes reportsGroupControls = toolbarData.toolbarFind(‘actions4’).controls; See more about actions4 here.
Read moreRun Java Programs in plsql
Java Class login to db server install java sdk sudo yum install java-1.8.0-openjdk‘ check java -v mdkr myJavaFile nano Square_Cube.java javac Square_Cube.java it creates a new file Square_Cube.class loadjava -thin -user db_user/db_pwd@localhost:1521/xepdb1 -resolve -verbose Square_Cube.class this will create a new java class entry in your db Java Source
Read more
PLSQL JSON_TABLE Examples
Create JSON from Cursor JSON_TABLES To convert json nested objects with arrays and sub arrays, Format JSON can be used Update JSON column node values Query from JSON column JSON propertity JSON where clause JSON PLSQL Types
Read more