…
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
syntax
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 sqlplus 連線 不用 tnsname 檔案的方法 / syntax
sqlplus account/[email protected]/service_name
sqlplus sys/[email protected]/oradb as sysdba
或
sqlplus /nolog
conn account/[email protected]/service_name