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 System/Linux/Unix*

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

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

Categories
DATABASE

Protected: [oracle] create user / schema syntax command

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

Categories
DATABASE Service Software

[memo] Ubuntu forgot mysql root password

Categories
DATABASE System/Linux/Unix*

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

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

Categories
DATABASE Programming/misc System/Linux/Unix*

Monster LAMP stack on Docker

Categories
DATABASE Service Software System/Linux/Unix*

Google : Google Cloud Platform , GCP ,

google.com – Google Cloud Platform‎

 

Screenshot 2015 10 07 10 58 08

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
DATABASE Programming/php

[PHP] Sample code : Berkeley DB , bdb , dba_open , db4 , key-value database ,

$id = dba_open("bdb4_tsid.db", "w", "db4");

if (!$id) { echo "dba_open failed\n"; exit; }

dba_replace("key", "This is an example!", $id);

if (dba_exists("key", $id)) {
        echo dba_fetch("key", $id);
        dba_delete("key", $id);
}

dba_close($id);

Screenshot 2015 05 13 20 28 39

 

 

Screenshot 2015 05 13 20 37 56

 

This is an example!
exist:
This is an example!
---> This is an example!

Categories
DATABASE Software

Windows regedit oracle setting