Skip to content

Instantly share code, notes, and snippets.

Avatar

Kris Rice krisrice

87 followers · 14 following
View GitHub Profile
@krisrice
krisrice / sqlcl_js_returning.js
Created Dec 20, 2022
View sqlcl_js_returning.js
//
//create table todo(id NUMBER GENERATED by default on null as IDENTITY, todo_for varchar2(200));
//
var DBUtil = Java.type("oracle.dbtools.db.DBUtil");
var binds={};
binds.name="Oliver";
sql = "insert into todo(todo_for) values(:name)";
@krisrice
krisrice / jetty-custom-access-log-ords.xml
Last active Dec 6, 2022
View jetty-custom-access-log-ords.xml
<?xml version="1.0"?>
<!DOCTYPE Configure PUBLIC "-//Jetty//Configure//EN" "https://www.eclipse.org/jetty/configure_10_0.dtd">
<!--
Drop this file into
../global/standalone/etc/jetty-accesslog.xml
-->
<!-- =============================================================== -->
@krisrice
krisrice / k6_io_test.js
Last active Nov 15, 2022
View k6_io_test.js
import http from "k6/http";
import encoding from 'k6/encoding';
/*
*
Run with No Auth
k6 run -e AUTH=NONE --vus 10 --iterations 100 k6.js
Run with OAuth
k6 run -e AUTH=OAUTH --vus 10 --iterations 100 k6.js
@krisrice
krisrice / rest_sql_batch_insert.js
Created Nov 5, 2022
View rest_sql_batch_insert.js
var fetch = require('node-fetch');
//
// generate random string
//
/*
Sample output
inserting :50000 rows
Rows:244,652
http: 7.429s
@krisrice
krisrice / ADB_list_buckets_with_RESOURCE_PRINCIPAL.sql
Created Oct 31, 2022
View ADB_list_buckets_with_RESOURCE_PRINCIPAL.sql
DECLARE
l_comp_ocid varchar2(200);
l_tenant_ocid varchar2(200);
all_buckets DBMS_CLOUD_OCI_IDENTITY_COMPARTMENT_TBL;
function lsComp(p_tenant_ocid varchar2,
p_region varchar2,
p_cred varchar2 default 'OCI$RESOURCE_PRINCIPAL',
p_page varchar2 default null) return DBMS_CLOUD_OCI_IDENTITY_COMPARTMENT_TBL
as
@krisrice
krisrice / kill.js
Created Oct 19, 2022
View kill.js
// 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 Oct 3, 2022
View sql-replay.html
<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
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"
@krisrice
krisrice / sql_oci_metrics.sql
Last active May 18, 2022
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
@krisrice
krisrice / load_strava.sql
Created Mar 2, 2022
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;