Re: Creating Table as select...

Example as requested - but the feature
appeared only in 9.2 (I think)

create table parent(

     id number primary key using index (create index par_pk on parent(id)) );

Anywhere you can put the 'using index' clause, you can include the (create index...) with any detail you like about the index.

-- 
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


Next public appearances:
 March 2004 Hotsos Symposium - The Burden of Proof
 March 2004 Charlotte NC OUG - CBO Tutorial
 April 2004 Iceland


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK___February
____UK___June


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


"Jon" <jsantarelli_at_molex.com> wrote in message
news:10e66e3.0402091215.18ca0d5a_at_posting.google.com...


> I realize that I can create the table then the index/constraint in

> seperate statements.  What I would like to do is to create them in the

> SAME STATEMENT.  I don't have a reason other than curiosity, I think

> it can be done, but I do not know, nor have I been able to figure out

> the syntax on how to do it.  If you are able to provide information on

> how to do it that would be nice.  What I don't care about is the

> philisophical debate on what is right or what is wrong.   I just want

> to know if I can do it and how to - period.

>

> Regards

> Jon