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 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 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
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…
Read more
My notes to create a simple AOP like server to process office documents(ongoing)
– create Linux server – install NPIO – create executables – install NodeJS / express – create end point to get json data + doc/excel template – store it onto the server – call executables to process them – save excel/doc – grab it with NodeJS and send it back to client https://stackoverflow.com/questions/34538825/node-js-call-external-exe-and-wait-for-output https://cloud.tencent.com/developer/article/1802670 https://github.com/nissl-lab/npoi-examples
Read more