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
Thanks Rich, I am going try this out on monday. Once I run some insert scripts.- urge262
- Post #4
- Forum: Oracle: All versions
-
-
SQL to bump up a sequence.
How would I go about doing that. Just learing about sequences Thanks- urge262
- Post #3
- Forum: Oracle: All versions
-
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
Leslie, Thank you! I was close! So the "1" means start at the first position right? Then find the length subtract 2 characters right to left because of the "-" negative 2 and return the string. thanks again!- urge262
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
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
Ok, last night i took out all my cards, RAM, Processor, IDE cables, Power cords, then put everything back in. It still didnt work right. I got the My Computer and Control Panel issues fixed. But the computer is terribly slow. The mouse moves quickly but when i try to open a program or WE it...- urge262
- Post #8
- Forum: Microsoft: Windows
-
XP PRO SP2 double clicking control panel XP asks "to create a shortcut
Alright, I'll try all of these tonight and get back to you. Thanks for the help!!- urge262
- Post #7
- Forum: Microsoft: Windows
-
XP PRO SP2 double clicking control panel XP asks "to create a shortcut
When I installed SP2 a few weeks ago I didnt have any problems. The day of my move my computer was running perfectly then after the move 2 days later I set everything up and ran into these problems on the first boot up after the move. Thats why I'm wondering why did all of these problems show...- urge262
- Post #5
- Forum: Microsoft: Windows
-
XP PRO SP2 double clicking control panel XP asks "to create a shortcut
Does this clear up the control pannel shortcut?- urge262
- Post #3
- Forum: Microsoft: Windows
-
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
