Follow Us on Twitter

[SQL] Reverse function

by Michel van Zoest on February 24, 2010 · 0 comments

Sometimes you can stumble across undocumented features in software. Oracle is no different. When reading Tom Kyte’s book Expert Oracle Database Architecture, I found out about the SQL function ‘Reverse’. This does exactly what it’s name implies: it reverses the result of your query.

select reverse(country_name)
from countries

Which produces the following result:

Turn around, every now and then...

Now ain’t that fun?
But remember: undocumented also means unsupported, so results aren’t deetnaraug…. ehm… guaranteed.

VN:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)

{ 0 comments… add one now }

Leave a Comment


Previous post:

Next post:

About Whitehorses
Company profile

Whitehorses website

Home page

Follow us
Blog post RSS
Comment RSS