Skip to content

Instantly share code, notes, and snippets.

View krisrice's full-sized avatar

Kris Rice krisrice

169 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 / 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
@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 / exportDDL.sql
Created May 4, 2017 14:10
script
var CopyOption = Java.type("java.nio.file.StandardCopyOption");
// put all files here >>>
var ddlPath = java.nio.file.FileSystems.getDefault().getPath('ddl')
var fs = java.nio.file.FileSystems.getDefault();
var f = java.nio.file.Files;
if ( ! f.exists(ddlPath)) {
f.createDirectory(ddlPath)
@krisrice
krisrice / sqlcl.sh
Last active September 1, 2023 12:59
sql() {
# REMOTE source this script
#
# . <(curl -s https://gist.githubusercontent.com/krisrice/fec43fd9f53e4286e5cc360b554e3c0f/raw/62ec382d7511c7cc44703a9a2f75a4a7f233efe2/sqlcl.sh)
# Set the stage directory
STAGE_DIR=/tmp
# Check whether internet connection exists
if ping -c 1 -t 3 download.oracle.com > /dev/null; then
@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 / 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==