How to replace large characters with small characters and small characters with large ones using Regex ORACLE?

S

S

sidor_tank2020-02-11 10:45:19

Oracle

sidor_tank, 2020-02-11 10:45:19

How to replace large characters with small characters and small characters with large ones using Regex ORACLE?

How to replace large characters with small characters and small characters with large ones using Regex ORACLE. This must be done for any line.

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

I

idShura, 2020-02-11
@idShura

select translate (str, lower(str) || upper(str),  upper(str) || lower(str)) from dual

Similar questions

A

Almik Oh! Give me a guitar2014-11-20 12:36:37

Oracle: why is there an error? 3Reply

A

alondrealit2017-01-06 08:49:31

What set of materials would you recommend? 0Reply

V

Vaper672017-01-16 05:20:31

How to get rid of the ORA-00704 error and preferably forever? 0Reply

N

NightFantom2015-01-25 19:47:54

What should be done to connect to Oracle DB as SYSDBA? 2Reply

D

Dmitry2019-06-25 00:14:55

Which indexes to choose for complex filtering? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question