DATABASE – Monster Oasis

[MEMO] A sample about create index in Elasticsearch/Kibana/Index Management aka ELK , 建立 ELK index 範例

2021/11/27 by Monster

[小測試] 使用不同種類的 Key-Value database 效能比較 / Berkeley DB / Redis / Memcache …

2020/01/21 by Monster

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

2017/03/272017/03/24 by Monster

…

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

Protected: [archive] Install Oracle Database 11gR2 on Ubuntu 12.04

2017/01/12 by Monster

Protected: [oracle] create user / schema syntax command

2016/03/102016/02/01 by Monster

[memo] Ubuntu forgot mysql root password

2016/01/17 by Monster

Protected: [memo] Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 6

2016/01/14 by Monster

Monster LAMP stack on Docker

2021/05/022015/12/12 by Monster

12366172 10204750981323960 193729036077101742 o

Oracle syntax: decode , 替換語法

2015/09/232015/09/23 by Monster

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’.