備忘録

例）・テーブルのデータ：ABC
　　・画面からの入力値：abc
SELECT * FROM (SELECT 'ABC' AS C1 FROM DUAL) WHERE C1 LIKE '%' || UPPER('abc') || '%';

ORDER BY DECODE(FUND_CODE, 'fundA', 1, 'fundB', 2, 'fundC', 3, 'fundD', 4, 'fundE', 5) ASC

SELECT col1 , RAWTOHEX(col1) , DUMP(col1,1016) FROM dual;

---