fyi, Oracle has a new tool called Raptor http://www.oracle.com/technology/products/database/project_raptor/index.html
I have been using it for a week now...nice. DK On 1/10/06, Stuart Kidd <[EMAIL PROTECTED]> wrote: > Thanks for that Hatton. I managed to get the query window open and put a > query inside but seem to get some errors. > > CREATE SEQUENCE PATCHID > MINVALUE 1 > MAXVALUE 999999999999999999999999999 > START WITH 1 > INCREMENT BY 1 > CACHE 20; > > Do you know whether my sequence should have a semi-colan at the end? Also, > the actual field name is called PATCHID, should i call this sequence > something else? > > If i take off the semi-colan and give the seq a random name it seems to come > up with no errors but is there a way i can see whether it actually did > anything? > > Thanks for your time, > > Saturday > > ---------------------------------------- > From: "C. Hatton Humphrey" <[EMAIL PROTECTED]> > Sent: Tuesday, January 10, 2006 11:40 AM > To: CF-Talk <cf-talk@houseoffusion.com> > Subject: Re: SOT: Aqua Studio / Oracle > > > I don't know whether anyone has used Aqua Studio before but in case you > > have then maybe you can help. > > > > I am trying to create a field with an incremental ID. I found this clever > > script: > > > > CREATE SEQUENCE supplier_seq > > MINVALUE 1 > > START WITH 1 > > INCREMENT BY 1 > > CACHE 20; > > > > but i have no idea where i should run that script. > > > > Is there a way to create a seq via the GUI? (I'm missing Enterprise > > Manager!) > > If you're talking about opening up a query window, select the server, > the database and the table on the left and hit CTRL-Q (or right click > and select New Query Window) > > Hatton > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229053 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54