krisrice

with colors as ( 
    select 'black' value  from dual
    union all
    select 'green'   from dual
    union all
    select 'yellow'   from dual
    union all
    select 'blue'   from dual
    union all
    select 'magenta'   from dual

gvenzl

Test Database Setup

Container creation

Podman run

Test database and user creation

• MySQL
• Postgres
• Oracle
• SQL Server

krisrice

REM Add to ORDS config
REM <entry key="procedure.rest.preHook">klrice.my_ords_ctx.populate</entry>

REM Create a context
CREATE OR REPLACE CONTEXT ords_params USING my_ords_ctx;

REM PKG to populate the context

CREATE OR REPLACE PACKAGE my_ords_ctx AS

rtyler

#!/usr/bin/env bash

FILENAME=${1}
# expected to be defined in the environment
#  - AZURE_STORAGE_ACCOUNT
#  - AZURE_CONTAINER_NAME
#  - AZURE_ACCESS_KEY

# inspired by

krisrice

//   npm install java

var java = require("java");

java.classpath.push("ojdbc8.jar");
java.classpath.push("oracle.dbtools-common.jar");
java.classpath.push("oracle.dbtools.http.jar");
java.classpath.push("oracle.dbtools.jdbcrest.jar");
java.classpath.push("oracle.sqldeveloper.sqlcl.jar");
java.classpath.push("xmlparserv2.jar");

varver

/* 
This code Do the following stuff :  
1) login to a website called : website.com by submitting password and username on the page with url :- http://website.com/login
2) Now after login using the cookies stored by this webiste access user profile page 
3) Now using same client which stored the required cookies make another post request to user profile page present at page :- 
http://website.com/upser_profile_page . 
4) Now get html of this whole page and print it in log as a string .
 
*/