Tuesday, January 19, 2016

UTL_RAW Functions in Oracle with Syntax

UTL_RAW.TO_RAW


Syntax
result := PGM_UTL.TO_RAW(input);


UTL_RAW.BIT_AND

Syntax
result := UTL_RAW.BIT_AND(input1, input2);


UTL_RAW.BIT_COMPLEMENT

Syntax
result := UTL_RAW.BIT_COMPLEMENT(input);


UTL_RAW.BIT_OR


Syntax
result := UTL_RAW.BIT_OR(input1, input2);

UTL_RAW.BIT_XOR


Syntax
result := UTL_RAW.BIT_XOR(input1, input2);


UTL_RAW.CAST_TO_RAW


Syntax
result := UTL_RAW.CAST_TO_RAW(input);


UTL_RAW.CAST_TO_VARCHAR2

Syntax
result := UTL_RAW.CAST_TO_VARCHAR2(input);

UTL_RAW.COMPARE

Syntax
result := UTL_RAW.COMPARE(input1, input2[, pad]);


UTL_RAW.CONCAT


Syntax
result := UTL_RAW.CONCAT(input1, ...  input12);


UTL_RAW.CONVERT


Syntax
result := UTL_RAW.CONVERT(input, new_charset, old_charset);

UTL_RAW.COPIES

Syntax
result := UTL_RAW.COPIES(input, number);

UTL_RAW.LENGTH 

Syntax
result := UTL_RAW.LENGTH(input);


UTL_RAW.OVERLAY

Syntax
result := UTL_RAW.OVERLAY(new_bytes, input, position, length, pad);


UTL_RAW.REVERSE

Syntax
result := UTL_RAW.REVERSE(input);

UTL_RAW.SUBSTR


Syntax
result := UTL_RAW.SUBSTR(input, position[,length]);


UTL_RAW.TRANSLATE

Syntax
result := UTL_RAW.TRANSLATE(input, match, replace_bytes);


UTL_RAW.TRANSLITERATE


Syntax
result := UTL_RAW.TRANSLITERATE (input, replace_bytes, match, pad);


UTL_RAW.XRANGE

Syntax
result := UTL_RAW.XRANGE(start, end);

No comments:

Post a Comment