<div>
I think the second one actually places two tildes in between any consecutive commas.
</div>


I think the second one actually places two tildes in between any consecutive commas.

<div>
It is important that you should understand these functions<br />
<br />
Here are the docs link:<br />
<br />
<a href="http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions131.htm" rel="ugc">http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions131.htm</a><br />
<br />
<a href="http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions134.htm" rel="ugc">http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions134.htm</a><br />

</div>


It is important that you should understand these functions

Here are the docs link:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions131.htm [http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions131.htm]

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions134.htm [http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions134.htm]


<div>
<div class="content wysiwyg-content">
Could you please explain this line<br />
<br />
lv_payer_code &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:= TO_CHAR(regexp_substr(lv_d<wbr />ataread, '[^,]+',1));<br />
<br />
lv_dataread &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:= replace(replace(i.data,',,<wbr />',',~~,'),<wbr />',,',',~~,<wbr />');
</div>
</div>


Could you please explain this line

lv_payer_code		:= TO_CHAR(regexp_substr(lv_dataread, '[^,]+',1));

lv_dataread		:= replace(replace(i.data,',,',',~~,'),',,',',~~,');

Could you please explain this line in PL/Sql procedure

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.