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 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
Oracle APEX Ords Oauth2 Notes
Create Role Create Privilege assign role to privilege Map privilege to pattern (modules/ parent end point ) defined in apex or with plsql api Create Client and give privilege created earlier Grant Role to Client Get Client_Id and Client_secret Test in Postman newer version of postman => Read more here.
Read more
Use Bastion Service to Connect To Autonomous DB within a private subnet PLSQL Developer
Validate VCN security list ingression rule. Find your database subnet check security list settings if 1522 ingress rule not existing, add it Create A Bastion in the same VCN or existing bastion in the same VCN where your Autonomous DB reside Create Session Open SSH Tunnel “-i <privateKey>” is not needed since we use public…
Read more
Oracle Cloud Infrastructure: Terraform
Installation of Terraform on your local machine On Mac run Installation of OCI CLI on your local machine Official OCI CLI installation guide: https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/cliinstall.htm#InstallingCLI__macos_homebrew After installation of OCI CLI and Terraform on your local Machine A guide to get start use Terraform with OCI connection to your OCI tenancy. How to make connections to your…
Read more