OraFAQ Forum: Server Administration » Can we play with strings?

Home » RDBMS Server » Server Administration » Can we play with strings?

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

Can we play with strings? [message #372979]

Tue, 20 March 2001 16:52

marco
Messages: 46
Registered: March 2001

Member

I'm trying to change strings like this one :

Joe Smith
INTO
SMITH, Joe

Can it be done? Thanks in advance.

Report message to a moderator

Re: Can we play with strings? [message #372987 is a reply to message #372979]

Tue, 20 March 2001 22:38

Thirumalai and Prakash
Messages: 23
Registered: March 2001

Junior Member

Hi Macro,
We can do like this
upper(substr(name,instr(name,' '))) ||', '|| substr(name,1,instr(name,' '))

S.Thirumalai

Report message to a moderator

Another Question [message #372991 is a reply to message #372979]

Wed, 21 March 2001 10:32

marco
Messages: 46
Registered: March 2001

Member

I don't understand what instr i should put to make
it happen. I have a table with thousands of names.
Tell me if this could work

update table_name
set column_name = upper(substr(name, ???(name, '')
etc.

Report message to a moderator

Re: Another Question [message #373005 is a reply to message #372979]

Wed, 21 March 2001 23:14

Thirumalai and Prakash
Messages: 23
Registered: March 2001

Junior Member

Hi Macro,

INSTR is a function can be used to find out location of a "string" within another "string"
Syntax is

INSTR("source string","search string").

You can update table as follows
UPDATE table_name set column_name=upper(substr(column_name,instr(column_name,' '))) ||', '|| substr(column_name,1,instr(column_name,' '));

And also, you can update

update table_name set column_name= upper(substr(
column_name,starting position,end position));

Hope it helps
S.Thirumalai

Report message to a moderator

Thank you [message #373013 is a reply to message #372979]

Thu, 22 March 2001 11:32

marco
Messages: 46
Registered: March 2001

Member

It helped a lot, thank you.

Marco

Report message to a moderator

Previous Topic:	Re: To remove blanks within a field
Next Topic:	Deleting Tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 29 05:22:22 CDT 2024