Curiosity - Reverse Function

[dr_gori]

There is a non-documented function:

Select all

SQL> select reverse('123456789') from dual; 
 
REVERSE(' 
--------- 
987654321 
 
SQL> select reverse('bom dia!') from dual; 
 
REVERSE( 
-------- 
!aid mob 
 
SQL> select reverse('GLUFKE') from dual; 
 
REVERS 
------ 
EKFULG

[charlesmafra]

Reverse can also be used for a loop being covered from the highest value for the lowest, as in the example ...


Good did not know the command Reverse as mentioned earlier, as this is a PL / SQL forum, I remembered this.

[anderson]

Another interesting example ...

Select all

select reverse('socorram me subino onibus em marrocos') frase from dual;

's: -o

[dr_gori]

There goes one more:

Select all

select reverse('A MALA NADA NA LAMA') frase from dual; 

: D

[leonchacal]

The interesting thing is that the reverse does not work like this:


Error report -
ORA-06550: Line 8, column 15:
PLS-00201: The 'reverse' identifier must be declared
or-06550: line 8, column 2:

[DanielNN]

Two more,: D

Select all

 
select reverse('Anotaram a data da maratona') frase from dual; 
 
select reverse('A man, a plan, a canal, Panama!') setence from dual;