title: convert multiline column one line column in oracle
body: <p>I have a table that contains three columns but one of them contains multiline text.I want to create another table from that row but adress column should be one line.</p>
  <p>My table is Student</p>
  <p>Table: Student</p>
  <pre><code>id  |  name  | address    
   1  |  John  | London Street`               
                 Capital square Number:3`
  </code></pre>
  <p>What I want to do is to create another table like that(Address column should be one line)</p>
  <pre><code>id | name | address 
  1  | John | London Street Capital square Number:3
  </code></pre>
  <p>My query is like that:</p>
  <pre><code>create table StudentTest as (select * from Student where id = 1)
  </code></pre>
  <p>Do you have any idea for PL/SQL?</p>