Re: dynamic value for sequence

"Ingo R. Kirchner" wrote:

> Hi Daniel,
>
> I'm just developing a vba routine in access to move access-tables to oracle
> server, so i like to send sql pass-through queries dynamicly to oracle.
> Therefore wouldn't it be better to have it a in one sql statement?
>
> Ingo
>
> "Daniel Morgan" <dmorgan_at_exesolutions.com> schrieb im Newsbeitrag
> news:3D908E6E.9CA85927_at_exesolutions.com...
> > "Ingo R. Kirchner" wrote:
> >
> > > Hi,
> > >
> > > I would like to create a sequence with a start value based on the
> maximal
> > > Value of the table
> > >
> > > something like
> > >
> > > create sequence software_seq
> > > start with (select max(softwareid) from software)+1
> > > increment by 1
> > > nomaxvalue;
> > >
> > > but it doesn't work this way
> > >
> > > any help appreciated, thanks in advance
> > >
> > > Ingo
> >
> > SELECT MAX(column_name) FROM table;
> >
> > CREATE SEQUENCE sequence_name START WITH <the number previously returned
> > here>
> >
> > unless you want to put it all together in code with dynamic SQL but I
> can't
> > imagine why.
> >
> > Daniel Morgan
> >

In theory yes. In practice ... you can do it by writing a stored procedure using native dynamic SQL. But I dislike spending hours to write and test something that can easily be done by hand in a few minutes.

Daniel Morgan Received on Tue Sep 24 2002 - 15:09:47 CDT