2019-06-28から1日間の記事一覧

ダンプ関数

DB

Oracle select DUMP('a',16) from dual;select DUMP('あ',16) from dual; select DUMP('a',1016) from dual;select DUMP('あ',1016) from dual; SELECT UTL_RAW.CAST_TO_VARCHAR2(HEXTORAW('61')) FROM DUAL;SELECT UTL_RAW.CAST_TO_VARCHAR2(HEXTORAW('E381…

分析関数

DB

Oracle create table tab1(col1 int,col2 int); insert into tab1 values(1,100);insert into tab1 values(1,110);insert into tab1 values(1,120);insert into tab1 values(2,100);insert into tab1 values(2,200);insert into tab1 values(3,10);insert in…