What is SYS_GUID() function? and what is the purpose of SYS_GUID function?

Oracle Apps Interview Questions › Category: PL/SQL › What is SYS_GUID() function? and what is the purpose of SYS_GUID function?

0 Vote Up Vote Down

Questions Master asked 10 years ago

1 Answers

0 Vote Up Vote Down

Shailender Thallam Staff answered 10 years ago

In Oracle PL/SQL, SYS_GUID is a built in function which returns the Global Unique Identifier (GUID) for a row in a table. It accepts no arguments and returns a RAW value of 16 bytes. Note that it is different from ROWID.

SYS_GUID can be used as a default value for a primary key column, which is often more convenient than using a sequence but its not recommended to use as it occupies more space.