Oracle EBS Technique Sharing

Thursday, October 29, 2020

How to replace enter in oracle

 select translate(your_column, chr(10)||chr(11)||chr(13), ' ') from your_table;

Posted by Finch Chen at 7:55 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Oracle

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Finch Chen
View my complete profile

Blog Archive

  • ►  2022 (5)
    • ►  September (1)
    • ►  May (1)
    • ►  March (3)
  • ►  2021 (4)
    • ►  April (1)
    • ►  January (3)
  • ▼  2020 (12)
    • ►  December (6)
    • ►  November (1)
    • ▼  October (2)
      • How to replace enter in oracle
      • Oracle Purchasing Tables
    • ►  May (2)
    • ►  January (1)
  • ►  2019 (13)
    • ►  November (1)
    • ►  October (4)
    • ►  September (1)
    • ►  July (3)
    • ►  June (1)
    • ►  February (1)
    • ►  January (2)
  • ►  2018 (35)
    • ►  December (3)
    • ►  November (9)
    • ►  October (2)
    • ►  September (3)
    • ►  August (6)
    • ►  July (4)
    • ►  June (8)
Awesome Inc. theme. Powered by Blogger.