Home » SQL & PL/SQL » SQL & PL/SQL » Problem with Data display (Oracle11g)
Problem with Data display [message #667732] Fri, 12 January 2018 03:38 Go to next message
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,
CI_
CH_ORDERS_DRACT

but I want it should be display like
"CI_CH_ORDERS_DRACT"

How can I resolve this?

Please help.

Thanks In advance.
Re: Problem with Data display [message #667733 is a reply to message #667732] Fri, 12 January 2018 03:39 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
That's a GUI issue, what GUI?
Re: Problem with Data display [message #667734 is a reply to message #667733] Fri, 12 January 2018 03:56 Go to previous messageGo to next message
ssyr
Messages: 65
Registered: January 2017
Member
Thank you for your prompt reply.

But I have resolve this issue.
Re: Problem with Data display [message #667735 is a reply to message #667734] Fri, 12 January 2018 04:09 Go to previous messageGo to next message
msol25
Messages: 396
Registered: June 2011
Senior Member
Hi ssyr,

Please can you provide what was the required change here?
Re: Problem with Data display [message #667738 is a reply to message #667735] Fri, 12 January 2018 05:42 Go to previous messageGo to next message
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 messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
ssyr wrote on Fri, 12 January 2018 05:42
HI ,

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.
Re: Problem with Data display [message #667741 is a reply to message #667738] Fri, 12 January 2018 08:14 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
And what happens whee there are two lines breaks?
Previous Topic: duplicate records with different date_from and date_to
Next Topic: How to replace with null for non alphanumeric characters in Varchar2 field.
Goto Forum:
  


Current Time: Fri Mar 29 08:57:38 CDT 2024