Thanks for the great comment. I have not tested it, but I think wwv_flow_id.next_val would have the same benefits as an identity column. wwv_flow_id.next_val is ever increasing; it is also highly sparse, globally unique, and extremely hard to guess. I greatly value all of these characteristics. I just want Oracle to make it easier to use wwv_flow_id.next_val in QuickSQL :)
Jon Dixon
APEX, ORDS & the Oracle Database
I used to always use SYS_GUID. I stopped when Identity Columns came along and when I heard that they took up so much space. Also, this is worth a read: raajeshwaran.blogspot.com/2016/12/guid-or-sequenc… I do still use SYS_GUID when I need unique values across instances.