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
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.
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…
Linux CLI Most Used Commands (ongoing)
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…
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…
Oracle 21 XE, APEX, ORDs, Nginx as Load Balancer, PLSQL WS Proxy Installation Notes
High level design Database & APEX installation Linux ORDs Installation Nginx load balancer configuration Nginx PLSQL Webservice Proxy server configuration High level design Database & APEX installation Oracle 21XE installation Oracle APEX installation Database Installation For Oracle 21XE installation, i would suggest to follow this oracle official guide, it is pretty straight forward. (I assume…
My notes to create a simple AOP like server to process office documents(ongoing)
Goal: shopping list: Test with POSTMAN Or On APEX PHP Code