SeqNum Numeric Summary The SeqNum function returns an increasing number beginning from an optional start number. Syntax SeqNum([start]) Return Type   Details The function restarts the count for...

SeqNum Summary The SeqNum function returns an increasing value each time it is called. Syntax SeqNum([start expression]) Return Type Long Details The returned value starts at 1 for each query. A new...

In our next exercise, we use SeqNum() and UUID() to generate number sequences (long data type) and random 128-bit Java UUIDs:   1 SQL> select SeqNum(1), UUID(), participant_id from xactly.xc_p...