Problem with Data display [message #667732] |
Fri, 12 January 2018 03:38 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/b80831ab52b38aed2eaf41e59e7fc54b?s=64&d=mm&r=g) |
ssyr
Messages: 65 Registered: January 2017
|
Member |
|
|
Hi All,
I am facing issue while fetching data form table .In my table I have store all table names.But some table name display in breaking format so it is display in next line such as output is as below,
but I want it should be display like
How can I resolve this?
Please help.
Thanks In advance.
|
|
|
|
|
|
Re: Problem with Data display [message #667738 is a reply to message #667735] |
Fri, 12 January 2018 05:42 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/b80831ab52b38aed2eaf41e59e7fc54b?s=64&d=mm&r=g) |
ssyr
Messages: 65 Registered: January 2017
|
Member |
|
|
HI ,
Sure , I used below Select ,
select replace(replace(replace(table_name,',',''),chr(10),''),chr(13),'')
from tablename
|
|
|
Re: Problem with Data display [message #667740 is a reply to message #667738] |
Fri, 12 January 2018 08:08 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/d29f577f753cb4b873212fd5ed0da4cd?s=64&d=mm&r=g) |
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
ssyr wrote on Fri, 12 January 2018 05:42HI ,
Sure , I used below Select ,
select replace(replace(replace(table_name,',',''),chr(10),''),chr(13),'')
from tablename
Which leads to the next question ... if the data is the name of a table, how did it get inserted with line breaks as part of the data? Sounds like you have put a band-aid to cover a fundamental problem with the way the data gets into the db in the first place.
|
|
|
|