How to generate a GUID in Oracle?

by

You can use the SYS_GUID() function to generate a GUID in your insert statement:

insert into mytable (guid_col, data) values (sys_guid(), 'xxx');

The preferred datatype for storing GUIDs is RAW(16).

As Gopinath answer:

 select sys_guid() from dual
 union all
 select sys_guid() from dual
 union all 
 select sys_guid() from dual

You get

88FDC68C75DDF955E040449808B55601
88FDC68C75DEF955E040449808B55601
88FDC68C75DFF955E040449808B55601

As Tony Andrews says, differs only at one character

88FDC68C75DDF955E040449808B55601
88FDC68C75DEF955E040449808B55601
88FDC68C75DFF955E040449808B55601

Maybe useful: http://feuerthoughts.blogspot.com/2006/02/watch-out-for-sequential-oracle-guids.html

More Related Contents:

  1. Get counts of all tables in a schema
  2. Determining location of relevant tnsnames.ora file
  3. List of foreign keys and the tables they reference in Oracle DB
  4. Default row ordering for select query in oracle
  5. ORA-28040: No matching authentication protocol exception
  6. hibernate oracle sequence produces large gap
  7. How to handle Day Light Saving in Oracle database
  8. Oracle Search all tables all columns for string [duplicate]
  9. Oracle PL/SQL – How to create a simple array variable?
  10. Number of rows affected by an UPDATE in PL/SQL
  11. Oracle’s default date format is YYYY-MM-DD, WHY?
  12. how to replace multiple strings together in Oracle
  13. Spool Command: Do not output SQL statement to file
  14. Convert epoch to date in sqlplus / Oracle
  15. Convert from Oracle’s RAW(16) to .NET’s GUID
  16. Is there any way to have the JBoss connection pool reconnect to Oracle when connections go bad?
  17. Get ID of last inserted record in oracle db
  18. oracle SQL plus how to end command in SQL file?
  19. Why is the GETDATE() an invalid identifier
  20. How to output result of SELECT statement which is executed using native dynamic SQL?
  21. ORA-04091: table [blah] is mutating, trigger/function may not see it
  22. How to use parameters in a ‘where value in…’ clause?
  23. How to convert “1985-02-07T00:00:00.000Z” (ISO8601) to a date value in Oracle?
  24. How to generate a version 4 (random) UUID on Oracle?
  25. Oracle SQL Developer: Show REFCURSOR Results in Grid?
  26. Find out the history of SQL queries
  27. How to test an Oracle Stored Procedure with RefCursor return type?
  28. Grant Select on all Tables Owned By Specific User
  29. Getting Error – ORA-01858: a non-numeric character was found where a numeric was expected
  30. ORA-12704: character set mismatch

Leave a Comment