Skip to content

Instantly share code, notes, and snippets.

View krisrice's full-sized avatar

Kris Rice krisrice

92 followers · 14 following
View GitHub Profile
@krisrice
krisrice / kill.js
Created October 19, 2022 13:18
// SQLCL's Command Registry
var CommandRegistry = Java.type("oracle.dbtools.raptor.newscriptrunner.CommandRegistry");
// CommandListener for creating any new command
var CommandListener = Java.type("oracle.dbtools.raptor.newscriptrunner.CommandListener")
// Broke the .js out from the Java.extend to be easier to read
var cmd = {};
// Called to attempt to handle any command
@krisrice
krisrice / sql-replay.html
Created October 3, 2022 19:27
<html>
<head>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/hack-font/3.3.0/web/hack.min.css" integrity="sha512-XgCw4Srl8lC1ECwcaHwAU0WnxQwHkqmInzg9wJLtGB7DRuMaXPuK2k9WJ2AwRDGdrgK9eJpZl2hUlLi2WQssmw==" crossorigin="anonymous" referrerpolicy="no-referrer" />
<script
src="https://code.jquery.com/jquery-2.2.4.min.js"
integrity="sha256-BbhdlvQf/xTY9gja0Dq3HiwQF8LaCRTXxZKRutelT44="
crossorigin="anonymous"></script>
<script src="https://mattboldt.com/demos/typed-js/js/typed.custom.js"></script>
<script>$( document ).ready(function() {
var data = [
@krisrice
krisrice / dbms_cloud_metric_sql_pkg.sql
Created May 20, 2022 15:26
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"
@krisrice
krisrice / sql_oci_metrics.sql
Last active May 18, 2022 20:08
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
@krisrice
krisrice / load_strava.sql
Created March 2, 2022 15:08
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;
@krisrice
krisrice / addMyIpWhiteList.sh
Last active June 14, 2022 21:09
#!/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")
@krisrice
krisrice / node-select.js
Created December 6, 2021 19:09
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 November 17, 2021 17:33
DBTools Service sample for REST-SQL
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;
@krisrice
krisrice / install-graaljs-sqlcl.sh
Last active July 24, 2023 09:40
#!/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")
@krisrice
krisrice / colors-all.sql
Created October 19, 2021 13:21
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