Ynt: rowid and create table as...

Steffen Ramlow <s.ramlow_at_gmx.de> wrote in message news:9g5ncd$7dp9f$1_at_ID-54600.news.dfncis.de...
> when i do:
> create table xxx as select empno, ename from emp order by ename;
>
> can i be sure that the rows are inserted into xxx ordered by ename and
 that
> the rowids are ascending?

I think it depends on the version you use...starting from oracle 8i you may use "create table xxx select ......from table ORDER BY ..." and the rows are inserted in the order which you chose..If I am wrong please correct me...

Murat

>
>
>
>
>
Received on Wed Jun 13 2001 - 00:20:39 CDT