云服务器内容精选

华为云首页用户手册

Oracle语法迁移

数据仓库服务 GaussDB(DWS)-SYS_GUID

SYS_GUID SYS_GUID是内嵌函数，返回表中某一行的全域唯一识别元（GUID）。SYS_GUID不使用参数，返回一个16字节的RAW值。输入 1 2 3 4 5 6 7 8 910111213141516171819 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 910111213141516171819 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*/ ); 父主题： Oracle语法迁移

数据仓库服务 GaussDB(DWS) Oracle语法迁移