Categories
Copy_N_Paste Programming/php

[PHP] Native SQLRELAY connect / query sample code

Categories
System/Linux/Unix*

Protected: [note] Install php7 oci8 on Ubuntu steps

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

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
Software

Navicat Premium Essentials : ORA-21561: OID generation failed

ORA-21561: OID generation failed  ….

Categories
DATABASE

Protected: [oracle] create user / schema syntax command

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

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

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 Software

Windows regedit oracle setting

Categories
DATABASE Software System/Linux/Unix*

在 Oracle Linux 6 安裝 Oracle database 11g R2 steps

netca , dbca

Connect as SYSTEM.

CREATE USER username IDENTIFIED BY apassword;

GRANT CONNECT TO username;

GRANT SELECT [, INSERT] [, UPDATE] [, DELETE] on schema.table TO username;