检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
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
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
