Re: SQL challenge - an undocumented feature.

Looking forward to it appearing on the website. I don't get it. The periods
have to be an alias for something though because when I try it I just get "missing
epression". They're illegal as a variable name so there has to be some funny
business set up before this happens.

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 Tue May 25 1999 - 13:44:37 CDT