Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to insert unique UUID for table primary key column?

User_AS6XDAug 27 2021

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.
crr_table_structure.PNG (69.74 KB)sample_table_data_with_uuidprimarykey.PNG (36.92 KB)

Added on Aug 27 2021

#advanced-queueing, #database, #database-key-features, #oracle, #plsql, #sql

1 comment

2,690 views