<div>
Check this out:<br />
<br />
<a href="http://www.oracle.com/technology/oramag/code/tips2003/052503.html" rel="ugc nofollow">http://www.oracle.com/technology/oramag/code/tips2003/052503.html</a>
</div>


Check this out:

http://www.oracle.com/technology/oramag/code/tips2003/052503.html [http://www.oracle.com/technology/oramag/code/tips2003/052503.html]

<div>
Thanks raopsn. Whats the syntax to run it. I can't seem to figure his out.
</div>


Thanks raopsn. Whats the syntax to run it. I can't seem to figure his out.

<div>
Excellent solution.<br />
Thanks raopsn 
</div>


<div>
<div class="content wysiwyg-content">
Hi all I have a requirement in Oracle 10g to run the substring command on a long datatype in a table. For example this is what I would like to do.<br />
note: col1 is LONG datatype<br />
<br />
select substr(col1,1,2000), substr(col1,2001,4001) &nbsp;from table1;<br />
I'd also like to run the trim function if possible from start to end.<br />
<br />
I remember someone in my last place had a pl/sql procedure with input/output variables. Can someone help.<br />
<br />
Thankss all.
</div>
</div>


Hi all I have a requirement in Oracle 10g to run the substring command on a long datatype in a table. For example this is what I would like to do.
note: col1 is LONG datatype

select substr(col1,1,2000), substr(col1,2001,4001)  from table1;
I'd also like to run the trim function if possible from start to end.

I remember someone in my last place had a pl/sql procedure with input/output variables. Can someone help.

Thankss all.

Substring Procedure for Long Data Type

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.