Categories
DATABASE

[memo] docker : wnameless/oracle-xe-11g , create database tsdb steps

docker run \
  --name ora11xe -d \
  -p 49160:22 \
  -p 49161:1521 \
  -v //mnt/data:/data \
  -v /etc/localtime:/etc/localtime:ro \
  -e ORACLE_ALLOW_REMOTE=true \
  wnameless/oracle-xe-11g

Categories
DATABASE

Oracle syntax: decode , 替換語法

Screenshot 2015 09 23 11 46 32

Examples

This example decodes the value warehouse_id. If warehouse_id is 1, then the function returns ‘Southlake’; if warehouse_id is 2, then it returns ‘San Francisco’; and so forth. If warehouse_id is not 1, 2, 3, or 4, then the function returns ‘Non domestic’.

Categories
Copy_N_Paste Programming/php

Protected: PHP exception handling : using try catch exception syntax sample code

This content is password protected. To view it please enter your password below:

Categories
DATABASE

筆記 oracle sqlplus 連線 不用 tnsname 檔案的方法 / syntax

sqlplus account/password@172.25.0.18x/service_name

sqlplus sys/password@172.30.0.48/oradb as sysdba

sqlplus /nolog

conn account/password@172.25.0.18x/service_name