<div>
normally, you should get them as is from database, and use them in your app as you like...<br />
<br />
in asp<br />
<br />

<pre><code id="code-20-42206077-1">&lt;p&gt;
Address: 
&lt;%# Eval(&quot;address1&quot;)%&gt;&lt;br&gt;
&lt;%# Eval(&quot;address2&quot;)%&gt;&lt;br&gt;
&lt;%# Eval(&quot;address3&quot;)%&gt;
&lt;/p&gt;</code></pre>
<br />
or some unknown language:<br />
<br />

<pre><code id="code-20-42206077-2">address = data.address1 + &quot;\n&quot; + data.address2 + &quot;\n&quot; + data.address3</code></pre>
<br />
all these kinds of formatting formatting issues should be done on app / client side...
</div>


normally, you should get them as is from database, and use them in your app as you like...

in asp



<p>
Address: 
<%# Eval("address1")%><br>
<%# Eval("address2")%><br>
<%# Eval("address3")%>
</p>


or some unknown language:



address = data.address1 + "\n" + data.address2 + "\n" + data.address3


all these kinds of formatting formatting issues should be done on app / client side...

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I have a table dept<br />
there are 3 address columns like address1,address2,address3<wbr /><br />
i have to get these 3 address columns &nbsp;as single value along with line separator.<br />
<br />
address:<br />
sathya street<br />
AP<br />
India<br />
<br />
i need to show it in 3 lines as single value called address.<br />
<br />
can some one suggest me how to do using orcle.<br />
<br />
Thanks
</div>
</div>


Hi Experts,

I have a table dept
there are 3 address columns like address1,address2,address3
i have to get these 3 address columns  as single value along with line separator.

address:
sathya street
AP
India

i need to show it in 3 lines as single value called address.

can some one suggest me how to do using orcle.

Thanks

how to do line separation in oracle while doing concatenation

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.