My Oracle Support Banner

How to Delete Line Feeds and Carriage Returns from Varchar2 Data (Doc ID 301693.1)

Last updated on DECEMBER 05, 2019

Applies to:

SQL*Plus - Version 8.1.7.4 and later
Information in this document applies to any platform.

Goal

How to delete carriage returns and line feeds contained within the varchar2 field data?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.