Skip to content

Instantly share code, notes, and snippets.

View krisrice's full-sized avatar

Kris Rice krisrice

91 followers · 14 following
View GitHub Profile
@krisrice
krisrice / quicksql.html
Created October 31, 2023 13:54
View quicksql.html
<!DOCTYPE html>
<html lang="en">
<head>
<title>QuickSQL Standalone</title>
<style>
html, body {
height: 100%;
width: 100%;
padding: 0;
margin: 0;
@krisrice
krisrice / trace_to_timestamp.sql
Created February 22, 2023 21:23
View trace_to_timestamp.sql
/*
*** 2023-02-22 05:03:44.482 (M18VE(3))
*** SESSION ID:(3405.27040) 2023-02-22 05:03:44.482
*** CLIENT ID:() 2023-02-22 05:03:44.482
*** SERVICE NAME:(sm18ve) 2023-02-22 05:03:44.482
*** MODULE NAME:(JDBC Thin Client) 2023-02-22 05:03:44.482
*** ACTION NAME:() 2023-02-22 05:03:44.482
*** CLIENT DRIVER:() 2023-02-22 05:03:44.482
*** CONTAINER ID:(3) 2023-02-22 05:03:44.482
@krisrice
krisrice / RaptorWebTamperMonkey.js
Created February 2, 2023 17:38
View RaptorWebTamperMonkey.js
// ==UserScript==
// @name Raptor Web
// @namespace http://localhost:8080/ords/klrice/
// @version 0.1
// @description try to take over the world!
// @author You
// @match http://localhost:8080/ords/klrice/*
// @grant none
// @run-at document-idle
// ==/UserScript==
@krisrice
krisrice / sqlcl_js_returning.js
Created December 20, 2022 21:57
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 December 6, 2022 19:53
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 November 15, 2022 22:36
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 November 5, 2022 01:14
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 October 31, 2022 15:46
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 October 19, 2022 13:18
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 October 3, 2022 19:27
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 = [