You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for UTL_RAW


1 to 20 of 127 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_RAW, 1 of 2

98 UTL_RAWThe UTL_RAW package provides SQL functions for manipulating RAW datatypes. This package is … a RAW and a CHAR datatype. UTL_RAW also includes subprograms that convert various COBOL number … formats to, and from, RAWs. UTL_RAW is not specific to the database environment, and it may actually be … package, instead of DBMS. This chapter

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_RAW, 2 of 2

Summary of UTL_RAW SubprogramsTable 98-1 UTL_RAW Subprograms   Subprogram Description CAST_FROM_BINARY_INTEGER Function Returns

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_RAW, 2 of 2

ParametersTable 98-3 CAST_FROM_NUMBER Function Parameters Parameter Description n The NUMBER value.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_RAW, 2 of 2

ReturnsTable 98-45 BIT_XOR Function Returns Return Description RAW Containing the "xor" of r1 and r2. NULL If either r1 or r2 input parameter was NULL.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_RAW, 2 of 2

SyntaxUTL_RAW.CAST_FROM_BINARY_INTEGER ( n IN BINARY_INTEGER endianess IN PLS_INTEGER DEFAULT BIG_ENDIAN) RETURN RAW;

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_RAW, 2 of 2

ParametersTable 98-28 COPIES Function Parameters Parameters Description r RAW to be copied n Number of times to copy the RAW (must be positive).

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_RAW, 2 of 2

Pragmaspragma restrict_references(xrange, WNDS, RNDS, WNPS, RNPS);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_RAW, 2 of 2

CAST_FROM_NUMBER FunctionThis function returns the binary representation of a NUMBER (in RAW). If include_length is TRUE, the first byte of the RAW returned encodes the number of valid bytes in the number (not including the length byte), and the result is padded to a fixed length of 22 bytes with arbitrary data. If include_length is FALSE, the RAW returned is variable length, with a maximum length of 21 bytes.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_RAW, 2 of 2

ReturnsTable 98-41 BIT_AND Function Returns Return Description RAW Containing the "and" of r1 and r2. NULL Either r1 or r2 input parameter was NULL.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_RAW, 2 of 2

CAST_TO_VARCHAR2 FunctionThis function converts a RAW represented using n data bytes into VARCHAR2 with n data bytes. Note: When casting to a VARCHAR2, the current Globalization Support character set is used for the characters within that VARCHAR2.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_RAW, 2 of 2

ErrorsTable 98-29 COPIES Function Errors Error Description VALUE_ERROR Either: - r is missing, NULL or 0 length - n < 1 - Length of result exceeds maximum length of a RAW

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_RAW, 2 of 2

Pragmaspragma restrict_references(cast_from_number, WNDS, RNDS, WNPS, RNPS);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_RAW, 2 of 2

SyntaxUTL_RAW.CAST_TO_BINARY_INTEGER ( r IN RAW endianess IN PLS_INTEGER DEFAULT BIG_ENDIAN) RETURN BINARY_INTEGER;

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_RAW, 2 of 2

SyntaxUTL_RAW.TRANSLITERATE ( r IN RAW, to_set IN RAW DEFAULT NULL, from_set IN RAW DEFAULT NULL, pad IN RAW DEFAULT NULL) RETURN RAW;

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_RAW, 2 of 2

Defaults and Optional ParametersTable 98-21 TRANSLITERATE Function Optional Parameters Optional Parameter Description from_set x'00 through x'ff. to_set To the NULL string and effectively extended with pad to the length of from_set as necessary. pad x'00'.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_RAW, 2 of 2

ParametersTable 98-40 BIT_AND Function Parameters Parameter Description r1 RAW to "and" with r2. r2 RAW to "and" with r1.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_RAW, 2 of 2

ReturnsThe binary representation of the NUMBER value.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_RAW, 2 of 2

SUBSTR FunctionThis function returns len bytes, starting at pos from RAW r.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_RAW, 2 of 2

ErrorsTable 98-23 TRANSLITERATE Function Errors Error Description VALUE_ERROR R is NULL or has 0 length.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_RAW, 2 of 2

ParametersTable 98-24 OVERLAY Function Parameters Parameters Description overlay_str Byte-string used to overlay target. target Byte-string which is to be overlayed. pos Position in target (numbered from 1) to start overlay. len The number of target bytes to overlay. pad Pad byte used when overlay len exceeds overlay length or pos exceeds target length.