更新时间:2024-03-04 GMT+08:00
分享

SYS_GUID

SYS_GUID是内嵌函数,返回表中某一行的全域唯一识别元(GUID)。SYS_GUID不使用参数,返回一个16字节的RAW值。

输入

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
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*/
  ); 

输出

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
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*/
  ); 
分享:

    相关文档

    相关产品