Results for RAWTOHEX


1 to 18 of 18 results.


SQL Reference, 10g Release 1 (10.1)

RAWTOHEX

RAWTOHEXSyntax rawtohex::= Description of the illustration rawtohex.gif Purpose RAWTOHEX converts raw to a … RAWTOHEX(raw_column) "Graphics" FROM graphics; Graphics -------- 7D See Also: "RAW and LONG RAW Datatypes " and HEXTORAW

Packages and Types Reference, 10g Release 1 (10.1)

157 UTL_I18N

Examples'); dbms_output.put_line(rawtohex(r)); end; / This returns a hex value of '616263646566C2AA'.

Packages and Types Reference, 10g Release 1 (10.1)

161 UTL_RAW

Operational Notesthrough remote procedure calls. With the RAW functions, you can manipulate binary data that was previously limited to the hextoraw and rawtohex functions.

Packages and Types Reference, 10g Release 1 (10.1)

95 DBMS_STREAMS

Examples= ' || RAWTOHEX(raw_tag)); END; / You can also display the value by querying the DUAL view: SELECT DBMS_STREAMS.GET_TAG FROM DUAL;

Security Guide, 10g Release 1 (10.1)

16 Developing Applications Using Data Encryption

Example of a Data Encryption PL/SQL Program('> Encrypted hex value: ' || rawtohex(UTL_RAW.CAST_TO_RAW(encrypted_raw))); decrypted_raw … : ' ||rawtohex(UTL_RAW.CAST_TO_RAW(encrypted_raw))); dbms_output.put_line('> ========= BEGIN TEST Mac … => raw_key); dbms_output.put_line('> Message Authentication Code: ' ||rawtohex(UTL_RAW.CAST_TO_RAW

SQL Reference, 10g Release 1 (10.1)

HEXTORAW

HEXTORAW('7D')); See Also: "RAW and LONG RAW Datatypes " and RAWTOHEX

Application Developer's Guide - Fundamentals, 10g Release 1 (10.1)

2 Selecting a Datatype

How Oracle Database Converts Datatypes: TO_NUMBER() TO_BINARY_FLOAT() TO_BINARY_DOUBLE() TO_CHAR() TO_NCHAR() TO_DATE() HEXTORAW() RAWTOHEX

SQL Reference, 10g Release 1 (10.1)

Datatype Comparison Rules

to CHAR,VARCHAR2,NCHAR,NVARCHAR2 to NUMBER to Datetime/Interval to RAW to ROWID to LONG,LONG RAW to…) — — — — — — — — from RAW RAWTOHEX RAWTONHEX — — — — — TO_BLOB — — from ROWID ROWIDTOCHAR

Release 1.8, 10g Release 1 (10.1)

Meeting Program Requirements

RAW and LONG RAW Valuescharacters "FF". The SQL function RAWTOHEX performs the same conversion.

User's Guide and Reference, 10g Release 1 (10.1)

3 PL/SQL Datatypes

RAW and LONG RAW Valuescharacters 'FF'. The function RAWTOHEX does the same conversion. A conversion is also necessary when you

Pro*COBOL® Programmer's Guide, 10g Release 1 (10.1)

4 Datatypes and Host Variables

4.12.5 RAW and LONG RAW Valuesthe pair of characters "FF". The SQL function RAWTOHEX performs the same conversion. A conversion is

Packages and Types Reference, 10g Release 1 (10.1)

22 DBMS_CRYPTO

Conversion Rulesdatatype in a VARCHAR2 database column, then use RAWTOHEX or UTL_ENCODE.BASE64_ENCODE to make it

Replication Administrator's Guide, 10g Release 1 (10.1)

7 Managing Capture, Propagation, and Apply

Managing Streams Tags for an Apply Process(); DBMS_OUTPUT.PUT_LINE('Tag Value = ' || RAWTOHEX(raw_tag)); END; / You also can display the tag value

User's Guide and Reference, 10g Release 1 (10.1)

2 Fundamentals of the PL/SQL Language

Summary of PL/SQL Built-In FunctionsHEXTORAW RAWTOHEX RAWTONHEX ROWIDTOCHAR TO_BINARY_DOUBLE TO_BLOB TO_BINARY_FLOAT TO_CHAR TO_CLOB TO_DATE

SQL Reference, 10g Release 1 (10.1)

SQL Functions

Single-Row FunctionsNUMTOYMINTERVAL RAWTOHEX RAWTONHEX ROWIDTOCHAR ROWIDTONCHAR SCN_TO_TIMESTAMP TIMESTAMP_TO_SCN

SQL Quick Reference, 10g Release 1 (10.1)

2 SQL Functions

Syntax for SQL FunctionsRATIO_TO_REPORT(expr) OVER ([ query_partition_clause ]) RAWTOHEX RAWTOHEX(raw) RAWTONHEX RAWTONHEX(raw) REF REF

SQL Reference, 10g Release 1 (10.1)

Contents

ContentsPOWERMULTISET_BY_CARDINALITY PRESENTNNV PRESENTV PREVIOUS RANK RATIO_TO_REPORT RAWTOHEX RAWTONHEX

Application Developer's Guide - Large Objects, 10g Release 1 (10.1)

14 LOB APIs for Basic Operations

14 LOB APIs for Basic Operations: */ DBMS_OUTPUT.PUT_LINE(rawtohex(Buffer)); Position:= Position + Amount; END LOOP; /* Closing the LOB is … if you have opened it: */ DBMS_LOB.CLOSE (Lob_loc); DBMS_OUTPUT.PUT_LINE(RAWTOHEX(substr(Buffer, 1 … you have opened it: */ DBMS_LOB.CLOSE (Lob_loc); DBMS_OUTPUT.PUT_LINE(rawtohex(substr(buffer,1,200





Was this page helpful?

Integrated Cloud Applications & Platform Services