krisrice

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

#
# 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",

krisrice

body{font-family: Hack,Slack-Lato,appleLogo,sans-serif;}

krisrice

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';

krisrice

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

krisrice

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

krisrice

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,

krisrice

//   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");

krisrice

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']},

krisrice

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