Re: SQL Challenge - but not a serious one

Correct - and it works with all sorts
of data types, even though the result
may be meaningless.

Gives you one option in version 7
for using a sequence number for
a pk/fk link without the problem
of localising all the inserts at one
end of the index.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Martin Douglas wrote in message <37B19F08.99360DFA_at_Boeing.com>...
>Consider:
>
>select reverse('abc') from dual;
>
>REV
>---
>cba
>1 row selected.
>
>
Received on Wed Aug 11 1999 - 11:11:57 CDT