select
UTL_INADDR.GET_HOST_ADDRESS('winofsql.jp') as IPアドレス
,UTL_INADDR.GET_HOST_NAME('127.0.0.1') as HOST名
,UTL_I18N.TRANSLITERATE('アイウエオ','hwkatakana_fwkatakana') as 半カナto全カナ
,FLOOR(DBMS_RANDOM.VALUE(1,20)) as 乱数
,DBMS_CRYPTO.RANDOMINTEGER() as ORACLE整数乱数
,UTL_ENCODE.TEXT_ENCODE (chr(0)||'lightbox'||chr(0)||'password',null,1) as PLAIN認証
,RAWTOHEX(DBMS_CRYPTO.HASH(
UTL_I18N.STRING_TO_RAW('123')
,2
)) as md5
,RAWTOHEX(DBMS_CRYPTO.MAC(
UTL_I18N.STRING_TO_RAW('5339717501972784@localhost')
,1
,UTL_I18N.STRING_TO_RAW('password')
)) as "CRAM-MD5"
,UTL_I18N.RAW_TO_CHAR(
UTL_ENCODE.BASE64_ENCODE(
UTL_I18N.STRING_TO_RAW('lightbox')
)
) as base64encode
from dual