Hi All,
I have a string in pl/sql which has 'New line' , 'Form Feed' , 'Carriage Return' , 'Horizontal / vertical Tab space' and many white space characters.
For eg:
variable1 varchar2(3000);
variable1 = 'Hello world hello world
Hello world Hello world Hello world
Hello world'
I require a query to remove all the spaces(specially it should remove \f,\t,\n,\v,\r) and the string should be looks as below
var 1 = ' Hello world Hello world Hello world Hello world Hello world Hello world '
Please help. Thanks in advance.