OraFAQ Forum: SQL & PL/SQL » Remove unwanted characters

Home » SQL & PL/SQL » SQL & PL/SQL » Remove unwanted characters (19c)

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

Remove unwanted characters [message #685914]

Mon, 25 April 2022 13:35

varunvir
Messages: 389
Registered: November 2007

Senior Member

Hi Experts,
Is there any command I can use to remove the unwanted characters in the tables?

Thanks,
Varun

Report message to a moderator

Re: Remove unwanted characters [message #685915 is a reply to message #685914]

Mon, 25 April 2022 13:48

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What do you mean?

Report message to a moderator

Re: Remove unwanted characters [message #685917 is a reply to message #685915]

Tue, 26 April 2022 09:12

varunvir
Messages: 389
Registered: November 2007

Senior Member

Hi Michel,
There are some junk characters that are in certain columns in the database.
The data is being copied and pasted on the frontend , So it creates junk characters when data actually goes in the tables on the backend.
Is there any command to get rid of junk characters?
Thanks,
Varun

Report message to a moderator