oracle
[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
Navicat Premium Essentials : ORA-21561: OID generation failed
ORA-21561: OID generation failed ….
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’.
在 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;