SYS_GUID

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.

Input

CREATE TABLE sad.fnd_data_change_logs_t
  (
    logid                    NUMBER,
    table_name               VARCHAR2 (40) NOT NULL /* ENABLE */
    ,table_key_columns        VARCHAR2 (200),
 table_key_values         VARCHAR2 (200),
 column_name              VARCHAR2 (40) NOT NULL /* ENABLE */
 ,column_change_from_value VARCHAR2 (200),
 column_change_to_value   VARCHAR2 (200),
 organization_id          NUMBER,
 created_by               NUMBER (15, 0) NOT NULL /* ENABLE */
 ,creation_date            DATE NOT NULL /* ENABLE */
 ,last_updated_by          NUMBER (15, 0) NOT NULL /* ENABLE */
 ,last_update_date         DATE NOT NULL /* ENABLE */
 ,last_update_login        NUMBER (15, 0) DEFAULT 0 NOT NULL /* ENABLE */
 ,description              VARCHAR2 (500),
 sys_id                   VARCHAR2 (32) DEFAULT Sys_guid( )
 /*, SUPPLEMENTAL LOG DATA (ALL) COLUMNS*/
  );

Output

CREATE TABLE sad.fnd_data_change_logs_t
  (
    logid                    NUMBER,
    table_name               VARCHAR2 (40) NOT NULL /* ENABLE */
    ,table_key_columns        VARCHAR2 (200),
 table_key_values         VARCHAR2 (200),
 column_name              VARCHAR2 (40) NOT NULL /* ENABLE */
 ,column_change_from_value VARCHAR2 (200),
 column_change_to_value   VARCHAR2 (200),
 organization_id          NUMBER,
 created_by               NUMBER (15, 0) NOT NULL /* ENABLE */
 ,creation_date            DATE NOT NULL /* ENABLE */
 ,last_updated_by          NUMBER (15, 0) NOT NULL /* ENABLE */
 ,last_update_date         DATE NOT NULL /* ENABLE */
 ,last_update_login        NUMBER (15, 0) DEFAULT 0 NOT NULL /* ENABLE */
 ,description              VARCHAR2 (500),
 sys_id                   VARCHAR2 (32) DEFAULT MIG_ORA_EXT.Sys_guid( )
 /*, SUPPLEMENTAL LOG DATA (ALL) COLUMNS*/
  );