Re: procedure and ddl commands?

dead wrote:

> Can someone help me.
> I wolud like to make procedure on server with creating tables, sequences and
> indexes.
> 1. can I put ddl commands in oracle procedures?
> 2. how to put create sequnce command with 'start with' value as result of
> 'select command' (I need max value +1 from table for next value of
> sequence) in procedure?

As Mark indicates ... with EXECUTE IMMEDIATE ... what is known as Native Dynamic SQL.

But the fact that you can does not mean you should. And in almost 100% of cases ... you absolutely should not.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)