OraFAQ Forum: Server Administration » Re: How do I locate a Carriage Return (ENTER) in a string

Home » RDBMS Server » Server Administration » Re: How do I locate a Carriage Return (ENTER) in a string

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

Re: How do I locate a Carriage Return (ENTER) in a string [message #370297]

Fri, 13 August 1999 17:57

Amit Chauhan
Messages: 74
Registered: July 1999

Member

Try using CHR(13) as the character to be searched in the INSTR builtin.
Amit

Report message to a moderator

Re: How do I locate a Carriage Return (ENTER) in a string [message #370320 is a reply to message #370297]

Mon, 23 August 1999 18:42

Dhirendra Kumar Jena
Messages: 1
Registered: August 1999

Junior Member

Amit,

The New Line character is CHR(10);

IF U run this query
"Select 'abc'||chr(10)||'def' from dual"
U will get in two lines like

abc
def

So search for chr(10) in INSTR.

Thanks

Dhirendra

Report message to a moderator

Previous Topic:	two-dimensional pl/sql table
Next Topic:	fnd_crypt_pkg

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Oct 01 02:19:16 CDT 2025