felclef

    // ==UserScript==
    // @name           crawl-gx-dataviews
    // @namespace      Utils
    // @description    crawl-gx-dataviews
    // @include        http://10.20.30.214/app/Dataviews.html
    // ==/UserScript==
     
    with(document)
    {
            titles = getElementsByClassName("titulosRosaBgc");

felclef

# -*- coding: cp1252 -*-
import os
import time
import re
import cx_Oracle

class Exec:
	debug = True
	
	@staticmethod

felclef

declare
  cursor c_sql_stmt is
    select
      cl.table_name,
      cl.column_name,
      'UPDATE '||cl.table_name||' set '||cl.column_name||' = :1 where regexp_like('||cl.column_name||', :2, ''i'')' as cmd
    from
      user_tab_columns cl
      inner join user_tables tb
        on tb.table_name = cl.table_name

felclef

begin
  for cur_rec in
    (
      select 
        object_name,
        object_type
      from
        user_objects
      where  
        status <> 'VALID'

felclef

{
	"cmd": ["sqlplus", "dummy/dummy@local", "@$file"],
	"selector": "source.sql",
	"encoding": "cp1252"
}

felclef

create or replace
  type sysuser as object (
    user_client_name varchar(100),
    user_version varchar(50),
    user_name varchar(100), 
    user_password varchar(100),
    user_db_host varchar(15)
  );
/