Skip to content

Instantly share code, notes, and snippets.

View krisrice's full-sized avatar

Kris Rice krisrice

102 followers · 14 following
View GitHub Profile
@krisrice
krisrice / emp_in_live_sql.html
Created June 10, 2025 22:58
<a
href="https://livesql.oracle.com/next/?compressed_code=H4sIAAAAAAAAE72YW3OiShDH3%252F0U%252FYaeCpbg%252FWztw4iThAQYz4C75dPWRCeRcxBcwHL99qe4KBCzQ8xlfUh0eobu%252BXXPhT%252FFJgDYy9Ddxn8DNmfA%252FBVM8cxp0NSEf7HN1uMVE8TsweNRG0DzWBS5SyAhW3o8b4e9G6%252BhByu%252BZWG84X4cpUOVHvDN1gsOPB2r%252B0tvt%252BIRMPg3cH34uePhAXjmr91oyDJoIWcxL%252FmE%252FdpdrmHveh48cIjXHLYs5H6cm4PHtC0JNm1oQ0OjGDkYHDQxcPakZgMA0q8WAWtuTjBtqlfQaV1lBguZGOAbototompT6eUGg2jJv8LQzQ0asWyHIt1yYHb%252FI%252FUxo7qJ6ALu8QKaR1%252BtRutLeV6VUPOprVkC5DEIufvkw3%252F8ACF%252F5CH3lxziIB1S4GgDOGte6Z2iCfnPnRsmDlh8GmIRcP1nPvkvN4qPzXmnZeDtNn65MXdWRZk8JCOJzZlFki85y17BEmcsy9COpjsyAaiYxrnFvKGZ5fx5tzrF0ySG5E%252FWZCOj0nt4BeopL6b5G1M%252BV3gh%252F9VsJtOsJjOb7nnn6yz1FoFrQrF%252BYz1PPuQfiq8xxZaG7bwez%252BpD9yMexhAGe3D9OCgvgF3k%252Bk%252Fgsw1f5ZmK2g3dsjF1QLcccl7ipao%252B1XGjBd%252BQMcc2NEHpXJ1CAwAJaRqZW45u3UhVg4W%252Fw4LQewmqYbIXA304HCtpG0Ru7Ab%252BC3GeglCrQTz7SBTbOCkTSdhrigwD2Vl4v3fVFbuykYFtsR%252FtVtfQDalz1BM7IjNMkaMTq8bbhNgOsZ5DT%252BoyDPZXeUE45Ee6Lh53%252FjJhnewVSxb
@krisrice
krisrice / 404.html
Created May 24, 2024 17:28
<html>
<head>
<script src="https://code.jquery.com/jquery-3.6.1.slim.min.js" integrity="sha256-w8CvhFs7iHNVUtnSP0YKEg00p9Ih13rlL9zGqvLdePA=" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/typeit/8.7.0/index.es.min.js" integrity="sha512-wfiZquj4Ld1EW8zxfGIRD09TcQMUl5A6QwT6zta+4B3VSYoNXCVc7dG7wq4pNcS9yf3A2pSqijULWbjFi8luVQ==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.2.0/css/all.min.css" integrity="sha512-xh6O/CkQoPOWDdYTDqeRdPCVd1SpvCA9XXcUnZS2FmJNp1coAFzvtCN9BmamE+4aHK8yyUHUSCcJHgXloTyT2A==" crossorigin="anonymous" referrerpolicy="no-referrer" />
<style>
@import 'https://cdnjs.cloudflare.com/ajax/libs/hack-font/3.3.0/web/hack.min.css';
body {
background : #bdc3c7 ;
@krisrice
krisrice / sample-p12.py
Created May 22, 2024 14:25
import oci
import base64
import os
import oracledb
from oci.config import from_file, validate_config
import time
from cryptography.hazmat.primitives.serialization \
import pkcs12, Encoding, PrivateFormat, BestAvailableEncryption
# Wallet directory
@krisrice
krisrice / quicksql.html
Created October 31, 2023 13:54
<!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
/*
*** 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
// ==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
//
//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
<?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
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
var fetch = require('node-fetch');
//
// generate random string
//
/*
Sample output
inserting :50000 rows
Rows:244,652
http: 7.429s