Forum Stats

  • 3,759,488 Users
  • 2,251,551 Discussions


How to insert unique UUID for table primary key column?

User_AS6XD Member Posts: 39 Red Ribbon

I have to load unique uuid(uuid for primary key column) for each row in my table. Please let me know how to generate unique uuid's and insert them while loading data into my table. Please share script for the same.I have attached table structure and sample data for better understanding, earlier for this table unique uuid's were generated in some api written in java, now i have to replicate uuid logic in oracle.