「Oracle」演算子で文字列を連結するサンプル

構文
SELECT カラムA ||カラムB
FROM NAME_TBL

操作例1

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
SELECT
'TOKYO' || '-YOHOHAMA' AS CFT
FROM
DUAL;
SELECT 'TOKYO' || '-YOHOHAMA' AS CFT FROM DUAL;
SELECT
  'TOKYO' || '-YOHOHAMA' AS CFT
FROM
  DUAL;

結果
CFT
TOKYO-YOKOHAMA

操作例2 (NVLと||組み合わせ)

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
SELECT
NVL(COL_A, '110') || NVL(COL_B, '119') AS CFT
FROM USER_TBL
SELECT NVL(COL_A, '110') || NVL(COL_B, '119') AS CFT FROM USER_TBL
SELECT
  NVL(COL_A, '110') || NVL(COL_B, '119')  AS CFT
 FROM USER_TBL

 

Oracle

Posted by arkgame