Re: SQL challenge - an undocumented feature.

Jonathan might still be in Belgium, beating up on DBA's who don't read his posts within five picoseconds of their being posted. ( sorry JL, couldn't resist! <g> )

No worries......

look up commitscn for starters........it's a cute little thing

Doug Cowles wrote in message <374AEF95.BA64DC6B_at_bigfoot.com>...
>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 - 01:13:55 CDT