krisrice’s gists

krisrice / sqlid-status.sql

Created October 14, 2021 01:09

krisrice / cmd-status.sql

Created October 14, 2021 00:22

	set scan off
	set define off
	script
	var StatusBarComponent = Java.type("oracle.dbtools.raptor.console.StatusBarComponent");

	var component = new StatusBarComponent() {
	getName: function() {
	return "cmdstatus";
	},
	getDescription: function() {

krisrice / beer-status.sql

Created October 14, 2021 00:06

	set scan off
	set define off
	script
	var StatusBarComponent = Java.type("oracle.dbtools.raptor.console.StatusBarComponent");

	var component = new StatusBarComponent() {
	getName: function() {
	return "beer";
	},
	getDescription: function() {

krisrice / Dockerfile

Created September 23, 2021 23:42

	from oraclelinux:8

	run yum-config-manager --add-repo=http://yum.oracle.com/repo/OracleLinux/OL8/oracle/software/x86_64
	run yum -y install ords

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 / gist:c6a8e01760adfda76c2f11c42574b276

Created March 9, 2021 16:05

objectstore.js

	var OCIProfiles = Java.type("oracle.dbtools.oci.OCIProfiles");
	var OCIRESTClient = Java.type("oracle.dbtools.oci.OCIRESTClient");
	var OCIRequest = Java.type("oracle.dbtools.oci.OCIRequest");
	var Instant = Java.type("java.time.Instant");
	var DateTimeFormatter = Java.type("java.time.format.DateTimeFormatter");
	var TemporalAccessor = Java.type("java.time.temporal.TemporalAccessor");
	var FileUtils = Java.type("oracle.dbtools.common.utils.FileUtils");
	var StandardCopyOption = Java.type("java.nio.file.StandardCopyOption");
	var Files = Java.type("java.nio.file.Files");
	var Paths = Java.type("java.nio.file.Paths");

krisrice / clob2file.sql

Created February 24, 2021 13:06

	script
	// issue the sql
	var binds = {}
	var ret = util.executeReturnList('select help_text,page_name from APEX_APPLICATION_PAGES where rownum=1 and help_text is not null',binds);

	// loop the results
	for (i = 0; i < ret.length; i++) {
	// debug is nice
	ctx.write( ret[i].PATH+ "\n");
	// get the CLOB stream

krisrice / ords_pool_status.html

Created January 19, 2021 17:57

	<html>
	<head>
	<link rel="stylesheet" href="//cdn.jsdelivr.net/npm/hack-font@3/build/web/hack-subset.css">
	<script>

	var refreshInteval;
	function poolListing(){
	// populate the list of pools

	fetch('http://localhost:8080/ords/_/instance-api/stable/database-pools-cache/',

krisrice / title_change.sql

Created August 14, 2020 12:28

	script

	var dbUser = util.executeReturnOneCol('select user from dual');

	var globalName = util.executeReturnOneCol('select global_name from global_name');

	var title = "sqlcl " +dbUser + "@" + globalName

	sqlcl.setStmt('!echo -ne "\033]0;'+title+'\007"');

krisrice / cloudshell_sqlcl.sh

Last active February 2, 2021 22:05

	#
	# Print current instances for autonomous db
	# Uses $OCI_TENANCY for compartment id since that is the "root"
	#
	cat > db.jq <<EOF
	.data[] \|
	."db-name" + "\tocid:" + .id ,
	"\t" + ."db-name" + "_low" ,
	"\tORDS Version: " + ."apex-details"."ords-version",
	"\tAPEX Version: " + ."apex-details"."apex-version",

Kris Rice krisrice