Category: PL/SQL

Run Java Programs in plsql

Posted on

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

PLSQL JSON_TABLE Examples

Posted on

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

Posted on

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.