Re: RETURNING clause oddity

Thomas,

Apart from the order in which you drop and create sequence and table, and the fact that you use a 'ctas' and I use a definition, our scripts match.

But where you get 101 on PRINT EMP_ID,
I get 102.

My platform for the test was NT 4.0; I've emailed the script and output to you direct.

--
Jonathan Lewis

Host to The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

Seminars on getting the best out of Oracle
See http://www.jlcomp.demon.co.uk/seminar.html

Screensaver or Lifesaver: http://www.ud.com
Use spare CPU to assist in cancer research.