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

There is no excerpt because this is a protected post.

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

There is no excerpt because this is a protected post.

Categories
Software

Navicat Premium Essentials : ORA-21561: OID generation failed

ORA-21561: OID generation failed  ….

Categories
DATABASE

Protected: [oracle] create user / schema syntax command

There is no excerpt because this is a protected post.

Categories
DATABASE System/Linux/Unix*

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

There is no excerpt because this is a protected post.

Categories
DATABASE

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

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;