What are the challenges you face when working across database platforms? Take the survey
Options

Generate Sequences on Varchar column

How do i generate sequences of data? It non-unique but sequential. The first 14 characters can be hardcoded, but the latter needs to be sequential, sum can be duplicates:
Hardcoded: 20170530183617
non-unique sequence:000000000000018855165,000000000000018855165 etc

20170530183617000000000000018855165
20170530183617000000000000018855169
20170530183617000000000000018855169
20170530183617000000000000018855173
20170530183617000000000000018855177
20170530183617000000000000018855177
Tagged:

Comments

  • Options
    Jessica RJessica R Posts: 1,319 Rose Gold 4
    Hi @marvinm,

    If you create a Python script that uses a for loop to create the needed strings, and then return an iterable to print through that list, would that work?

    Jessica Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


Sign In or Register to comment.