Skip to content

Instantly share code, notes, and snippets.

View title_change.sql
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"');
View cloudshell_sqlcl.sh
#
# Print current instances for autonomous db
# Uses $OCI_TENANCY for compartment id since that is the "root"
#
cat > db.jq <<EOF
.data[] |
."db-name" ,
"\t" + .id ,
"\t" + ."db-name" + "_low" ,
"\n\tSDW: " + ."connection-urls"."sql-dev-web-url",
View klrice-slack.css
body{font-family: Hack,Slack-Lato,appleLogo,sans-serif;}
View awr_report_via_ords.sql
DECLARE
l_roles owa.vc_arr;
l_patterns owa.vc_arr;
l_modules owa.vc_arr;
BEGIN
l_roles(1) := 'SQL Developer';
l_patterns(1):= '/dba/*';
l_modules(1) := 'dba/awr';
View conditional-comp-autonomous.sql
set serveroutput on
CREATE OR REPLACE PROCEDURE is_adb AS
BEGIN
$IF $$is_autonomous $THEN
dbms_output.put_line('Yup');
$ELSE
dbms_output.put_line('No');
$END
View prehook-context.sql
REM Add to ORDS config
REM <entry key="procedure.rest.preHook">klrice.my_ords_ctx.populate</entry>
REM Create a context
CREATE OR REPLACE CONTEXT ords_params USING my_ords_ctx;
REM PKG to populate the context
CREATE OR REPLACE PACKAGE my_ords_ctx AS
View compile.js
var request = require('request'),fs = require('fs'),colors = require('colors');
var url = "http://KLRICE:klrice@localhost:9090/ords/klrice/_/sql"
// loop args 0="node" 1="compile" 2...= files to send
for (var i = 2; i < process.argv.length; i++) {
fs.createReadStream(process.argv[i]).pipe(request.post({
url : url,
proxy:'',
method: 'POST',
time:true,
View nodeSQLCL.js
// npm install java
var java = require("java");
java.classpath.push("ojdbc8.jar");
java.classpath.push("oracle.dbtools-common.jar");
java.classpath.push("oracle.dbtools.http.jar");
java.classpath.push("oracle.dbtools.jdbcrest.jar");
java.classpath.push("oracle.sqldeveloper.sqlcl.jar");
java.classpath.push("xmlparserv2.jar");
View ddl.js
var ddl = (function () {
function DDL() {
this.options = {
//columnNamePrefix: "?",
"Object Prefix": {value:"a"},
Schema: {value:"hr"},
"On Delete": {value:'Cascade',check:['Cascade','Restrict','Set Null']},
Compression: {value:'No',check:['Yes','No']},
"Include Drops": {value:'No',check:['Yes','No']},
"Date Data Type":{value:'DATE',check:['DATE','TIMESTAMP','Timestamp with time zone','Timestamp with local time zone']},
View tree.js
var tree = (function(){
var tab= ' ';
function ddlnode( x, inputLine, parent ) {
this.x = x;
this.y = function() {
if( this.children.length == 0 )
return this.x+1;
else
return this.children[this.children.length-1].y();
};
You can’t perform that action at this time.