Alt+Shift+S, R Batch getter/setter generation


select * from ALL_SYNONYMS where synonym_name = 'my_name';
select * from ALL_VIEWS where view_name = 'my_name';


See http://docs.oracle.com/cd/B19306_01/server.102/b14231/views.htm

#!/bin/bash

updatedb --prunepaths='
/proc /cygdrive/c/program_disk/cygwin
/cygdrive/c/Documents.and.Settings/[^/]*/Local.Settings/Temp
/cygdrive/c/Program.Files
/cygdrive/c/ProgramData
/cygdrive/c/Windows
/cygdrive/[^/]*/System.Volume.Information
/cygdrive/c/$Recycle.Bin
/home/hongyu.zhang/dumpster
'
​

CREATE USER my_account IDENTIFIED BY my_password;

GRANT ALL PRIVILEGE TO my_account;

#!/usr/bin/perl -w

## A safer program to replace unix command "rm"
## Author: Hongyu Zhang

if($#ARGV < 0) {
    die("Usage:  $0 filename\n");
}

$dir = `echo ~/dumpster`;
chomp $dir;
mkdir $dir unless(-d $dir);

for($i=0; $i<=$#ARGV; $i++) {
    croak("Directory $ARGV[$i] not existed") unless(-e $ARGV[$i]);
    my @arr = split /\//, $ARGV[$i];
    if(-e "$dir/$arr[$#arr]") {
        $command = "rm -rf $dir/$arr[$#arr]";
        system("$command");
        croak("error running command: $command") if($?);
    }

    $command = "mv -fv $ARGV[$i] $dir";
    system("$command");
    croak("error running command: $command") if($?);
}