Re: concatenate RAW data in PL/SQL with R7.3.2

If you look in $ORACLE_HOME/rdbms/admin for files "*raw*" in versions 7.1.6 and up you should find the utl_raw package that has entries:

desc utl_raw.BIT_AND
desc utl_raw.BIT_COMPLEMENT
desc utl_raw.BIT_OR
desc utl_raw.BIT_XOR
desc utl_raw.CAST_TO_RAW
desc utl_raw.CAST_TO_VARCHAR2
desc utl_raw.COMPARE
desc utl_raw.CONCAT
desc utl_raw.CONVERT
desc utl_raw.COPIES
desc utl_raw.LENGTH
desc utl_raw.OVERLAY
desc utl_raw.REVERSE
desc utl_raw.SUBSTR
desc utl_raw.TRANSLATE
desc utl_raw.TRANSLITERATE
desc utl_raw.XRANGE
 

You can use:

  utl_raw.cast_to_raw(utl_raw.cast_to_varchar2(a)||utl_raw.cast_to_varchar2(b))

among other things.

Install this package as SYS using svrmgrl or sqldba.

On 29 Aug 1996 09:13:30 -0400, mtsao_at_cas.org wrote:

>
>In PL/SQL there are concatenation operator and function for VARCHAR2
>datatype and its subtype -- "||", concat() -- to put string together
>such as:
>
> DECLARE
> string1 VARCHAR(10) := 'one';
> string2 VARCHAR(10) := ' piece';
> string3 VARCHAR(20);
> BEGIN
> string3 := string1 || string2;
> END
>
>
>but there is no such such built-in function for RAW datatype.
>
>Is there any techniques available in PL/SQL to concatenate RAW datatype ?
>
>Thanks in advance, Ming Tsao
>--

Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com                          

http://govt.us.oracle.com -- Check out our web site! Brand new, uses Oracle Web Server and Database

statements and opinions are mine and do not necessarily reflect the opinions of Oracle Corporation Received on Fri Aug 30 1996 - 00:00:00 CEST