Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

INSTR Newline or Carriage Returns

dtjasonbMay 28 2009 — edited May 29 2009
This seems to be a fairly simple question but I'm in need of figuring a way how to find the position of 2 new lines in a row from text in VARCHAR2 column. I would have though I could do the follwoing example would work but it doesnt' work as expected.

INSTR(columnX, char(13)char(13))

If someone could take pity and through me a bone on this I would appreciate it.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 26 2009
Added on May 28 2009
8 comments
5,422 views