<Additional information about your API call. Try to use verbs that match both request type (fetching vs modifying) and plurality (one vs multiple).>
-
URL
<The URL Structure (path only, no root url)>
-
Method:
| ################################################################################ | |
| require 'oci8' | |
| require 'iconv' | |
| ################################################################################ | |
| class OracleReader | |
| ################################################################################ | |
| def initialize(server, username, password) | |
| # Open the connection. | |
| @connection = OCI8.new(username, password, server) |
| # coding:utf-8 | |
| # usage: ruby oracle_to_csv.rb > sample.csv | |
| require 'rubygems' | |
| require 'oci8' # before you need install : gem install ruby-oci8 | |
| def csvout(user, pass, world, sql) | |
| begin | |
| ora = OCI8.new(user,pass,world) | |
| c = ora.exec(sql) |
| # encoding: utf-8 | |
| # | |
| # Prerequisite: | |
| # gem install ruby-oci8 | |
| require 'oci8' | |
| def log(message) | |
| puts "#{Time.now.strftime("%Y-%m-%d %H:%M:%S")} #{message}" | |
| end |
Prereq:
apt-get install zsh
apt-get install git-coreGetting zsh to work in ubuntu is weird, since sh does not understand the source command. So, you do this to install zsh
wget https://github.com/robbyrussell/oh-my-zsh/raw/master/tools/install.sh -O - | zsh
| DROP TYPE Student; | |
| DROP TYPE Person; | |
| CREATE OR REPLACE TYPE Person As Object ( | |
| firstName VARCHAR2(30), | |
| lastName VARCHAR2(30), | |
| phoneNumber CHAR(10) | |
| ) NOT FINAL; | |
| / | |
| CREATE OR REPLACE TYPE Student UNDER Person ( |