OraFAQ Forum: SQL & PL/SQL » Problem with Data display

Home » SQL & PL/SQL » SQL & PL/SQL » Problem with Data display (Oracle11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem with Data display [message #667732]

Fri, 12 January 2018 03:38

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.

Report message to a moderator

Re: Problem with Data display [message #667733 is a reply to message #667732]

Fri, 12 January 2018 03:39

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

That's a GUI issue, what GUI?

Report message to a moderator

Re: Problem with Data display [message #667734 is a reply to message #667733]

Fri, 12 January 2018 03:56

ssyr
Messages: 65
Registered: January 2017

Member

Thank you for your prompt reply.

But I have resolve this issue.

Report message to a moderator

Re: Problem with Data display [message #667735 is a reply to message #667734]

Fri, 12 January 2018 04:09

msol25
Messages: 396
Registered: June 2011

Senior Member

Hi ssyr,

Please can you provide what was the required change here?

Report message to a moderator

Re: Problem with Data display [message #667738 is a reply to message #667735]

Fri, 12 January 2018 05:42

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

Report message to a moderator

Re: Problem with Data display [message #667740 is a reply to message #667738]

Fri, 12 January 2018 08:08

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.

Report message to a moderator

Re: Problem with Data display [message #667741 is a reply to message #667738]

Fri, 12 January 2018 08:14

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

And what happens whee there are two lines breaks?

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 30 02:26:15 CDT 2023