<div>
<div class="content wysiwyg-content">
Hi I am trying to figure out how to load data into variables using PLSQL. &nbsp;I have been using substr to load the data into each variable. &nbsp;For example,<br />
<br />
vStockNum &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:= substr(vBuffer,1,instr(vBu<wbr />ffer,vTab,<wbr />1,1));<br />
<br />
vBuffer is a line from what the UTL_FILE variable is reading in. &nbsp;The problem I am having is the part named vTab. &nbsp;How do you search for a tab. &nbsp;If it was a comma, it would be ',' but since we are dealing with a tab rather than a punctuation mark its more challenging. &nbsp;I've tried doing the manual way of ' &nbsp; &nbsp; ', but that doesn't work either. &nbsp;Any ideas on what I could try?
</div>
</div>


Hi I am trying to figure out how to load data into variables using PLSQL.  I have been using substr to load the data into each variable.  For example,

vStockNum           	:= substr(vBuffer,1,instr(vBuffer,vTab,1,1));

vBuffer is a line from what the UTL_FILE variable is reading in.  The problem I am having is the part named vTab.  How do you search for a tab.  If it was a comma, it would be ',' but since we are dealing with a tab rather than a punctuation mark its more challenging.  I've tried doing the manual way of '     ', but that doesn't work either.  Any ideas on what I could try?

Using substr/instr on a tab delimited txt file

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.