Oracle ALTER SEQUENCE - START WITH not working?
· ☕ 1 min read
I googled over many websites explaining the error code and suggesting you do not change it. What if you really need to? One approach is to call NEXTVAL as many times to shift the sequence, so that it starts with your START WITH number (<SW>). A better one is to change INCREMENT BY to a certain value instead, then do NEXTVAL and revert INCREMENT BY.

PowerShell - Query Oracle Database
· ☕ 2 min read
You might have already googled other pages to help you on this. You even probably have found some PowerShell function like the one below [...] Still something makes this one different. Here are some tricks used here [...]