Skip to content

Instantly share code, notes, and snippets.

View jsbin.ewEmAfeb.html
<!DOCTYPE html>
<html>
<head>
<link rel="stylesheet" href="http://code.jquery.com/ui/1.10.3/themes/smoothness/jquery-ui.css">
<script src="http://code.jquery.com/jquery-1.9.1.js"></script>
<script src="http://code.jquery.com/ui/1.10.3/jquery-ui.js"></script>
View jsbin.uBOKogiV.html
<!DOCTYPE html>
<html>
<head>
<link rel="stylesheet" href="http://code.jquery.com/ui/1.10.3/themes/smoothness/jquery-ui.css">
<script src="http://code.jquery.com/jquery-1.9.1.js"></script>
<script src="http://code.jquery.com/ui/1.10.3/jquery-ui.js"></script>
View jsbin.ImoKaFOV.html
<!DOCTYPE html>
<html>
<head>
<link href="http://code.jquery.com/mobile/latest/jquery.mobile.css" rel="stylesheet" type="text/css" />
<script src="http://code.jquery.com/jquery-1.9.1.min.js"></script>
<script src="http://code.jquery.com/mobile/latest/jquery.mobile.js"></script>
<script src="http://cdnjs.cloudflare.com/ajax/libs/knockout/2.2.1/knockout-min.js"></script>
<script src="http://cdnjs.cloudflare.com/ajax/libs/knockout.mapping/2.3.5/knockout.mapping.js"></script>
<meta charset=utf-8 />
<title>SQL Developer Exchange Requests</title>
View gist:5980512fa83f72779b69
#!/usr/bin/env python
import urllib.request, csv, random, re
u='https://raw.githubusercontent.com/bridgetkromhout/devops-against-humanity/master/cards-DevOpsAgainstHumanity.csv'
white=[]
black=[]
lines = urllib.request.urlopen(u).read().decode('utf-8').split('\n')
for line in lines:
r=line.split(",")
View login.sql
set define ^
set sqlformat ansiconsole
//script longops.js klrice klrice
script
var dbUser="NOONE";
var ps1="";
if ( conn ) {
dbUser = util.executeReturnOneCol('select user from dual');
View sqlcl error checking
try {
var first = util.executeReturnOneCol("select 1 from dualx");
ctx.write('\n\n FIRST: ' + first + '\n\n');
} catch (e ) {
ctx.write('\n\n ERROR' + e + '\n\n');
}
sqlcl.setStmt('select X from YZ');
sqlcl.run();
View sqlcl_prompt_for_password.js
var System = Java.type("java.lang.System");
reader = ctx.getProperty("script.runner.jline");
var passwd = reader.readLine(null, 0); // 0 means don't echo
System.out.println("\nGot Password:" + passwd);
View snark.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
View autocorrect.js
var fatFinger = [ { bad:"form", good:"from"},
{ bad:"hwere", good:"where"},
{ bad:"dula", good:"dual"}
];
// SQLCL's Command Registry
View history_super_size.sql
script
var MultiLineHistory = Java.type("oracle.dbtools.raptor.console.MultiLineHistory");
MultiLineHistory.getInstance().setMaxItems(1000);
/