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

M

maxwolf2014-02-12 13:01:11

Convert NUMBER to otl types: how? 1Reply

M

ma232021-12-02 21:52:38

How to speed up table creation in ORACLE? 0Reply

B

beduin012018-09-28 12:37:59

Why does the Oracle connection library weigh so much? 1Reply

F

fart2014-03-11 12:28:04

Which node.js module to use to connect to oracle9i? 1Reply

E

Egor Ivan.2020-08-26 12:04:05

What could be the problem with querying Oracle database on wordpress (status 500)? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question