Home » Developer & Programmer » Forms » SQL Data Formatting
SQL Data Formatting [message #82108] Wed, 23 April 2003 06:39 Go to next message
Jeslie
Messages: 26
Registered: April 2003
Junior Member
Hi

I have a column description which has multiline data(Entered through frontend multiline textbox using enter key)

while selecting the column through a query it is displayed as entered (multiline)

What function can I use to select the description in a single line

Thanks

Report message to a moderator

Re: SQL Data Formatting [message #82120 is a reply to message #82108] Fri, 25 April 2003 00:43 Go to previous message
Zaire
Messages: 36
Registered: October 2002
Member
Hi Jeslie,

Dont know if there's a specific formatting function for this. But here's an alternative:

select replace('this
is
my
multiline
text',chr(10),' ')
from dual;

Report message to a moderator

Previous Topic: History of Forms and Reports and the new concepts incorporated
Next Topic: Order of trigger firing in forms 6i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 13:58:40 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.