Question : Select with remove white spaces in sql
Answered by : dark-deer-t54237nnzh0z
select RTRIM(FIRST_NAME) from employee
Source : http://a4academics.com/interview-questions/53-database-and-sql/397-top-100-database-sql-interview-questions-and-answers-examples-queries | Last Update : Sun, 06 Jun 21
Question : sql to remove all white space and special characters
Answered by : eddie
regexp_replace( nvl(column1,':'), '\\s+|[][!"#$%&\'()*+,.\\\\/:;<=>?@\^_`{|}~-]+', '')
Source : | Last Update : Wed, 15 Feb 23