SQL Language (MOSC)

MOSC Banner

substitute string with another string in a table.field

edited Jul 1, 2018 5:01AM in SQL Language (MOSC) 2 commentsAnswered

Hello

the field USERS.CELL_NUMBER  has the following definition.

Datatype VARXCHAR2 size : 255 CHAR.  with this query I get all the conntents with '⁺' (that indicate 00 international prefix)

select first_name, last_name, username, cell_number from ELD2016S.USERS where CELL_NUMBER LIKE '%+%';

I need to substitute (replace)  all the character '+' with string '00'.

could you please help by giving the sql command to perform this .

thanks regards

Giorgio

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center