How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
98 UTL_RAW → The 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
Summary of UTL_RAW Subprograms → Table 98-1 UTL_RAW Subprograms Subprogram Description CAST_FROM_BINARY_INTEGER Function Returns
Parameters → Table 98-3 CAST_FROM_NUMBER Function Parameters Parameter Description n The NUMBER value.
Returns → Table 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.
Syntax → UTL_RAW.CAST_FROM_BINARY_INTEGER ( n IN BINARY_INTEGER endianess IN PLS_INTEGER DEFAULT BIG_ENDIAN) RETURN RAW;
Parameters → Table 98-28 COPIES Function Parameters Parameters Description r RAW to be copied n Number of times to copy the RAW (must be positive).
Pragmas → pragma restrict_references(xrange, WNDS, RNDS, WNPS, RNPS);
CAST_FROM_NUMBER Function → This 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.
Returns → Table 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.
CAST_TO_VARCHAR2 Function → This 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.
Errors → Table 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
Pragmas → pragma restrict_references(cast_from_number, WNDS, RNDS, WNPS, RNPS);
Syntax → UTL_RAW.CAST_TO_BINARY_INTEGER ( r IN RAW endianess IN PLS_INTEGER DEFAULT BIG_ENDIAN) RETURN BINARY_INTEGER;
Syntax → UTL_RAW.TRANSLITERATE ( r IN RAW, to_set IN RAW DEFAULT NULL, from_set IN RAW DEFAULT NULL, pad IN RAW DEFAULT NULL) RETURN RAW;
Defaults and Optional Parameters → Table 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'.
Parameters → Table 98-40 BIT_AND Function Parameters Parameter Description r1 RAW to "and" with r2. r2 RAW to "and" with r1.
Returns → The binary representation of the NUMBER value.
SUBSTR Function → This function returns len bytes, starting at pos from RAW r.
Errors → Table 98-23 TRANSLITERATE Function Errors Error Description VALUE_ERROR R is NULL or has 0 length.
Parameters → Table 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.