View quicksql.html
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!DOCTYPE html> | |
<html lang="en"> | |
<head> | |
<title>QuickSQL Standalone</title> | |
<style> | |
html, body { | |
height: 100%; | |
width: 100%; | |
padding: 0; | |
margin: 0; |
View trace_to_timestamp.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
*** 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 | |
View RaptorWebTamperMonkey.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// ==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== |
View sqlcl_js_returning.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// | |
//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)"; |
View jetty-custom-access-log-ords.xml
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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 | |
--> | |
<!-- =============================================================== --> |
View k6_io_test.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
View rest_sql_batch_insert.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
var fetch = require('node-fetch'); | |
// | |
// generate random string | |
// | |
/* | |
Sample output | |
inserting :50000 rows | |
Rows:244,652 | |
http: 7.429s |
View ADB_list_buckets_with_RESOURCE_PRINCIPAL.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
View kill.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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 |
View sql-replay.html
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<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 = [ |
NewerOlder