检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
date_lt_timestamp date_lt_timestamptz date_mi date_mi_interval date_mii date_ne date_ne_timestamp date_ne_timestamptz date_out date_pl_interval date_pli date_recv date_send date_smaller date_sortsupport daterange_canonical daterange_subdiff datetime_pl datetimetz_pl dcbrt decode defined degrees delete
create table tab_2(col2 char(3)); gaussdb=# insert into tab_2 values(' '); gaussdb=# insert into tab_1 select col2 from tab_2; gaussdb=# select * from tab_1 where col1 is null; col1 ------ (1 row) gaussdb=# select * from tab_1 where col1=' '; col1 ------ (0 rows) gaussdb=# delete
Return type: varchar2(16) analyze_tgtype_for_event(n smallint) Description: Parses pg_trigger.tgtype, parses n by bit, and returns one or more of insert, update, delete, and truncate. Return type: varchar2(246) nanvl(n2, n1) Description: The input includes two parameters.
f1 := DBE_FILE.FOPEN('dir', 'sample1.txt', 'w'); f2 := DBE_FILE.FOPEN('dir', 'sample2.txt', 'w'); DBE_FILE.CLOSE_ALL(); IF DBE_FILE.IS_CLOSE(f1) = true and DBE_FILE.IS_CLOSE(f2) = true THEN DBE_OUTPUT.PRINT_LINE('f1 and f2 all closed'); END IF; -- Delete
f1 := DBE_FILE.FOPEN('dir', 'sample1.txt', 'w'); f2 := DBE_FILE.FOPEN('dir', 'sample2.txt', 'w'); DBE_FILE.CLOSE_ALL(); IF DBE_FILE.IS_CLOSE(f1) = true and DBE_FILE.IS_CLOSE(f2) = true THEN DBE_OUTPUT.PRINT_LINE('f1 and f2 all closed'); END IF; -- Delete
Return type: varchar2(16) analyze_tgtype_for_event(n smallint) Description: Parses pg_trigger.tgtype, parses n by bit, and returns one or more of insert, update, delete, and truncate. Return type: varchar2(246) nanvl(n2, n1) Description: The input includes two parameters.
t1 "_REMOTE_TABLE_QUERY_" (cost=0.00..0.00 rows=20 width=12) Node/s: All datanodes -> Hash (cost=0.00..0.00 rows=20 width=12) -> Data Node Scan on t "_REMOTE_TABLE_QUERY_" (cost=0.00..0.00 rows=20 width=12) Node/s: All datanodes (7 rows) Delete
Only simple DELETE statements are supported. For example: DELETE FROM t1 WHERE c1 = ? and c2 = 10; Columns c1 and c2 are index columns, which can be followed by constants or parameters. Only simple UPDATE statements are supported. For example: UPDATE t1 SET c3 = c3+?
Reserved DECODE Non-reserved (excluding functions and types) N/A N/A DEFAULT Reserved Reserved Reserved DEFAULTS Non-reserved N/A N/A DEFERRABLE Reserved Reserved Reserved DEFERRED Non-reserved Reserved Reserved DEFINED N/A Non-reserved N/A DEFINER Non-reserved Non-reserved N/A DELETE
v_info,v_in,v_offset); -- Output the result. dbe_output.print_line('id:'|| v_id || ' info:' || v_info); end loop; -- Close the cursor. dbe_sql.sql_unregister_context(context_id); end; / -- Call the stored procedure. openGauss=# call pro_dbe_sql_all_02(HEXTORAW('DEADBEEF'),0,1); -- Delete
SM_CARRIER(61,20), SM_CONTRACT(82,20)) header; gaussdb=# COPY tpcds.ship_mode_t1 FROM '/home/omm/ds_ship_mode_fixed.dat' FIXED FORMATTER(SM_SHIP_MODE_SK(0, 2), SM_SHIP_MODE_ID(2,16), SM_TYPE(18,30), SM_CODE(50,10), SM_CARRIER(61,20), SM_CONTRACT(82,20)) header ignore_extra_data; -- Delete
datetime_typ_tab; -- Create a table. gaussdb_m=# CREATE TABLE year_typ_tab(col1 year, col2 year(4)); -- Insert data. gaussdb_m=# INSERT INTO year_typ_tab VALUES ('2023', now()); -- View the data. gaussdb_m=# SELECT * FROM year_typ_tab; col1 | col2 ------+------ 2023 | 2023 (1 row) -- Delete
datetime_typ_tab; -- Create a table. gaussdb_m=# CREATE TABLE year_typ_tab(col1 year, col2 year(4)); -- Insert data. gaussdb_m=# INSERT INTO year_typ_tab VALUES ('2023', now()); -- View the data. gaussdb_m=# SELECT * FROM year_typ_tab; col1 | col2 ------+------ 2023 | 2023 (1 row) -- Delete
create table tab_2(col2 char(3)); gaussdb=# insert into tab_2 values(' '); gaussdb=# insert into tab_1 select col2 from tab_2; gaussdb=# select * from tab_1 where col1 is null; col1 ------ (1 row) gaussdb=# select * from tab_1 where col1=' '; col1 ------ (0 rows) gaussdb=# delete
Oracle Database: The return value is the number of affected rows for INSERT, UPDATE, and DELETE statements and is meaningless for other statements. 17 EXECUTE_AND_FETCH Function RUN_AND_NEXT Function - 18 FETCH_ROWS Function NEXT_ROW Function - 19 GET_NEXT_RESULT Procedures Not supported
Oracle Database: The return value is the number of affected rows for INSERT, UPDATE, and DELETE statements and is meaningless for other statements. 17 EXECUTE_AND_FETCH Function RUN_AND_NEXT Function - 18 FETCH_ROWS Function NEXT_ROW Function - 19 GET_NEXT_RESULT Procedures Not supported
If the table is not a user table, migrate data to the corresponding table in the pg_catalog schema and delete the table in the original public schema.
gaussdb_m gaussdb_m=# CREATE TABLE t1(id int DEFAULT 100, name varchar(20) DEFAULT 'tt'); gaussdb_m=# INSERT INTO t1 VALUES(1,'test'); -- Execute the query. gaussdb_m=# SELECT default(id), default(name) FROM t1; default | default ---------+--------- 100 | tt (1 row) -- Delete
If the table is not a user table, migrate data to the corresponding table in the pg_catalog schema and delete the table in the original public schema.
gaussdb_m gaussdb_m=# CREATE TABLE t1(id int DEFAULT 100, name varchar(20) DEFAULT 'tt'); gaussdb_m=# INSERT INTO t1 VALUES(1,'test'); -- Execute the query. gaussdb_m=# SELECT default(id), default(name) FROM t1; default | default ---------+--------- 100 | tt (1 row) -- Delete
