Re: SQL challenge - an undocumented feature.

Nice problem,

I wonder why is number field LEFT justified?

Vitaliy Mogilevskiy

Jonathan Lewis wrote:

> An interesting, undocumented feature of Oracle
>
> create table test_table (n1 number);
>
> insert into test_table values (.......);
> 1 row inserted
>
> select * from test_table;
> N1
> ----------
> 492345
>
> commit;
>
> select * from test_table;
>
> N1
> ----------
> 492349
>
> TEST_TABLE is owned by me,
> no-one has any privileges to access it,
> and I guarantee that no other process
> accessed for the entire transaction.
>
> Apart from Thomas Kyte who knows
> what I inserted into the table.
>
> All will be revealed on my web-site
> some time next week.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: www.jlcomp.demon.co.uk
Received on Thu May 20 1999 - 19:32:55 CDT