Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL to bump up a sequence's Last Value
I have a sequence on a table and I need to bump it up. Sequence Name: SQ_SRVC_CT the Last Value: 43 I need the last value changed to 1155 so that the next record will have an ID of 1156. I tried: Alter sequence SQ_SRVC_CT next value 1155 but I get the error: ORA-02286: no options specified...- urge262
- Thread
- Replies: 3
- Forum: Oracle: All versions
-
SQL to bump up a sequence.
I have a sequence on a table and I need to bump it up. Secuence Name: SQ_SRVC_CT the Last Value: 43 I need the last value changed to 1155 so that the next record will have an ID of 1156. I tried: Alter sequence SQ_SRVC_CT next value 1155 but I get the error: ORA-02286: no options specified...- urge262
- Thread
- Replies: 4
- Forum: Oracle: All versions
-
SQL Query in Oracle
Hello, I am trying to write a query in Oracle. Here is a sample of the data for the CUST_ID field. -----CUST_ID--------------------------------- CITFRAVIR01 DHL01 ARINC57 PFIZER11 CARAIRSAN01 --------------------------------------------- I need to write a query that strips off the last 2...- urge262
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
-
XP PRO SP2 double clicking control panel XP asks "to create a shortcut
I am running XP Pro SP2, 450 mhz 512mb. Issue #1: Bios boots fine but, when i get to windows it takes for ever to load up my startup programs, norton, logitech ifeel drivers etc... Once everything is loaded i try opening programs and it just basically chokes. After a few minutes the programs...- urge262
- Thread
- Replies: 8
- Forum: Microsoft: Windows
