Home » SQL & PL/SQL » SQL & PL/SQL » Re: Sequence Problem Very Urgent
Re: Sequence Problem Very Urgent [message #2702] Wed, 07 August 2002 04:00
santosh
Messages: 85
Registered: October 2000
Member
hi
what i can see here is another solution to your problem.Since you stated that the first twelve characters are standard you can do one way that "select max(id) + 1 from emp where id like '0101010208%' "this may help you out.for faster access you can use indexes for search in the query

Santosh
Previous Topic: INSERT ROWS - DOES NOT WORK
Next Topic: prevent drop of table
Goto Forum:
  


Current Time: Thu Mar 28 18:37:30 CDT 2024