OraFAQ Forum: SQL & PL/SQL » remove whitespace

Home » SQL & PL/SQL » SQL & PL/SQL » remove whitespace

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

remove whitespace [message #513770]

Wed, 29 June 2011 06:08

soru05
Messages: 21
Registered: April 2011
Location: india

Junior Member

Dear All,

I want to remove whitespace from oracle database, and i don't want to use trim() or replace(). can i use jdbc driver? if yes, then how?

Thanks in advance.

Regards
Saurabh

Report message to a moderator

Re: remove whitespace [message #513771 is a reply to message #513770]

Wed, 29 June 2011 06:13

S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom

Senior Member

Quote:

I want to remove whitespace from oracle database, and i don't want to use trim() or replace(). can i use jdbc driver? if yes, then how?

What does remove whitespace has to do with jdbc driver? Why you don't want to use trim or replace ?

Regards

Raj

Report message to a moderator

Re: remove whitespace [message #513776 is a reply to message #513771]

Wed, 29 June 2011 06:41

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

Senior Member
Account Moderator

And what does mean "I want to remove whitespace"?

Regards
Michel

Report message to a moderator

Re: remove whitespace [message #513779 is a reply to message #513776]

Wed, 29 June 2011 06:47

soru05
Messages: 21
Registered: April 2011
Location: india

Junior Member

In database, if any string is "saurabh "
and i want to correct it like this "saurabh"
and there is many whitespaces in database.

Report message to a moderator

Re: remove whitespace [message #513781 is a reply to message #513779]

Wed, 29 June 2011 06:53

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

Senior Member
Account Moderator

A database is a set of schemas
A schema is a set of tables
A table is a set of columns
What paremeters, among those ones, have you?
Or do you want to remove ALL spaces in ALL columns of ALL tables in ALL schemas?

Regards
Michel

Report message to a moderator