Category Archives: 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
Protected: [archive] Install Oracle Database 11gR2 on Ubuntu 12.04
There is no excerpt because this is a protected post.
Protected: [oracle] create user / schema syntax command
There is no excerpt because this is a protected post.
[memo] Ubuntu forgot mysql root password
Protected: [memo] Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 6
There is no excerpt because this is a protected post.
Monster LAMP stack on Docker
Google : Google Cloud Platform , GCP ,
google.com – Google Cloud Platform
Oracle syntax: decode , 替換語法
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’.
[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); This is an example! exist: This is an example! —> This is an example!