<div>
LONG RAW data types works the same as varchar2. <br />
<br />
declare<br />
l2 long raw;<br />
l1 long raw;<br />
begin<br />
select raw_col INTO l2 from &lt;tableA&gt;;<br />
l1:=substr(l2, 356789,55);<br />
end;<br />
/<br />
<br />

</div>


LONG RAW data types works the same as varchar2.

declare
l2 long raw;
l1 long raw;
begin
select raw_col INTO l2 from <tableA>;
l1:=substr(l2, 356789,55);
end;
/



<div>
i need the data in ascii it's look how hexa
</div>


i need the data in ascii it's look how hexa

<div>
The function RAWTOHEX converts raw to a character value containing its hexadecimal equivalent. <br />
<a href="http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10759/functions110.htm" rel="ugc">http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10759/functions110.htm</a>
</div>


The function RAWTOHEX converts raw to a character value containing its hexadecimal equivalent.
http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10759/functions110.htm [http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10759/functions110.htm]

<div>
i need to convert the raw to char
</div>


<div>
Forced accept.<br />
<br />
Computer101<br />
EE Admin
</div>


<div>
<div class="content wysiwyg-content">
Hi, <br />
<br />
Exists character data in a table in format long raw, and I need to read this data in long raw and how to write in pl/sql in oracle 10gr2<br />
<br />
regards<br />
<br />
Gerid Garcia
</div>
</div>


Hi, 

Exists character data in a table in format long raw, and I need to read this data in long raw and how to write in pl/sql in oracle 10gr2

regards

Gerid Garcia

how read and write in column long raw in PL/SQL

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.