Home » SQL & PL/SQL » SQL & PL/SQL » linefeed in a column
linefeed in a column [message #4427] Sun, 08 December 2002 15:54 Go to next message
Amit
Messages: 166
Registered: February 1999
Senior Member
Hi,
How can I print hidden characters in SQLPLUS - for example, linefeed.

One of my columns ( a 'comment') column has linefeed characters in it and SQLPLUS is not displaying it properly.

Thanks and regards
Amit Kumar

Report message to a moderator

Re: linefeed in a column [message #4428 is a reply to message #4427] Sun, 08 December 2002 16:39 Go to previous message
Amit
Messages: 166
Registered: February 1999
Senior Member
Hi,
After a lil research i cud come up with a solution :
replace (column_name,CHR(10), '#'). CHR(10) is for linefeed which will be replaced by #.

Any better solutiion ?

Amit

Report message to a moderator

Previous Topic: creating a procedure problems.
Next Topic: Error with this populate script. Any Insight?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 16 04:04:11 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.