Skip to Main Content

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!

remove new line

Oracle_MonkeyDec 21 2018 — edited Dec 21 2018

with t as

  (

  select '10

  ' str from dual

  )

 

  select str,length(str)

from t;

"10

  " 5

How to remove the new line

Comments
Post Details
Added on Dec 21 2018
27 comments
3,883 views