SQL challenge - an undocumented feature.

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 20 May 1999 17:59:55 +0100
Message-ID: <927219769.12734.0.nnrp-13.9e984b29@news.demon.co.uk>

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 - 11:59:55 CDT