Re: RETURNING clause oddity

In article <997034967.26511.0.nnrp-13.9e984b29_at_news.demon.co.uk>, "Jonathan says...
>
>
>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.
>

thanks -- its the difference between the CTAS and CREATE TABLE in our examples....

you used a NUMBER, it does not reproduce with a NUMBER(4)....

When I create table emp ( empno number, ename varchar2(15) )

it reproduces (in 901 on down)

When I create table emp ( empno number(4), ename varchar2(15) );

it does not (replace 4 with any number 1..38 and it does not).

I filed it....

>--
>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.
>
>
>
>
>
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp