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(); | |
}; |
NewerOlder