Skip to content

Instantly share code, notes, and snippets.

View addMyIpWhiteList.sh
#!/bin/bash
OCIPROFILE="MYPROFILE"
DBOCID="ocid1.autonomousdatabase.oc1.phx.anyhqljrcsc5xxqnxxxxxxxxxxxxxxxxxxxxxxxxkulv5ipmbqiq"
REGION="us-phoenix-1"
#
# GET my IP Address
#
# Example : "1.2.3.4"
CURRENT_IP=$(oci raw-request --profile $OCIPROFILE --target-uri https://database.${REGION}.oraclecloud.com/20160918/autonomousDatabases/capabilities --http-method GET | jq ".data.clientIpAddress")
View colors-all.sql
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
View dbms_cloud_metric_sql_pkg.sql
create or replace package oci_metrics as
--
-- ╔═╗┌─┐┌┬┐┬ ┬┌─┐ ╔═╗┌┬┐┌─┐┌─┐┌─┐
-- ╚═╗├┤ │ │ │├─┘ ╚═╗ │ ├┤ ├─┘└─┐
-- ╚═╝└─┘ ┴ └─┘┴ ╚═╝ ┴ └─┘┴ └─┘
--
-- Current PDB's OCID
-- select json_value(cloud_identity , '$.DATABASE_OCID') from v$pdbs
--
-- Crate Dynamic Group "klrice-testing"
View sqlcl.sh
sql() {
# REMOTE source this script
#
# . <(curl -s https://gist.githubusercontent.com/krisrice/fec43fd9f53e4286e5cc360b554e3c0f/raw/62ec382d7511c7cc44703a9a2f75a4a7f233efe2/sqlcl.sh)
# Set the stage directory
STAGE_DIR=/tmp
# Get current ETAG from download
ETAG=`curl -I -s https://download.oracle.com/otn_software/java/sqldeveloper/sqlcl-latest.zip | tr -d '\r' | sed -En 's/^ETag: (.*)/\1/p'`
View sql_oci_metrics.sql
set serveroutput on
DECLARE
credential_name varchar2(200) := 'OCI$RESOURCE_PRINCIPAL';
region varchar2(200) := 'us-phoenix-1';
base_uri varchar2(200) := 'https://telemetry-ingestion.' || region|| '.oraclecloud.com/20180401/metrics';
resp dbms_cloud_types.RESP;
BEGIN
-- Current PDB's OCID
-- select json_value(cloud_identity , '$.DATABASE_OCID') from v$pdbs
View load_strava.sql
set load scan_rows 10000
drop table strava_activities;
drop table strava_applications;
drop table strava_bikes;
drop table strava_blocks;
drop table strava_clubs;
drop table strava_comments;
drop table strava_components;
drop table strava_connected_apps;
drop table strava_contacts;
View node-select.js
const common = require("oci-common");
const databasetools = require("oci-databasetools");
const secrets = require("oci-secrets");
const core = require("oci-core");
const fs = require("fs");
const oracledb = require('oracledb');
//
// Configure Instant Client
//
@krisrice
krisrice / DBToolsServiceRestSQLExamples.java
Last active Nov 17, 2021
DBTools Service sample for REST-SQL
View DBToolsServiceRestSQLExamples.java
package io.krisice;
import com.oracle.bmc.http.signing.RequestSigningFilter;
import javax.ws.rs.client.*;
import javax.ws.rs.core.MediaType;
import java.io.BufferedReader;
import java.io.IOException;
import java.io.Reader;
View install-graaljs-sqlcl.sh
#!/bin/bash
# MAVEN DEPS
declare -a array=("https://repo1.maven.org/maven2/org/graalvm/truffle/truffle-api"
"https://repo1.maven.org/maven2/org/graalvm/regex/regex"
"https://repo1.maven.org/maven2/com/ibm/icu/icu4j"
"https://repo1.maven.org/maven2/org/graalvm/sdk/graal-sdk"
"https://repo1.maven.org/maven2/org/graalvm/js/js"
"https://repo1.maven.org/maven2/org/graalvm/js/js-scriptengine")
View sqlid-status.sql
set scan off
set define off
script sqlid.js
set statusbar add sqlid