检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Format of with_query: with_query_name [ ( column_name [, ...] ) ] AS [ [ NOT ] MATERIALIZED ] ( {SELECT | VALUES | INSERT | UPDATE | DELETE} ) – with_query_name specifies the name of the result set generated by a subquery.
(4) )DISTRIBUTE BY HASH (CT_COL1); -- Insert data. gaussdb=# INSERT INTO char_type_t1 VALUES ('ok'); -- Query data in the table. gaussdb=# SELECT ct_col1, char_length(ct_col1) FROM char_type_t1; ct_col1 | char_length ---------+------------- ok | 4 (1 row) -- Delete
ResultSet rs = null; rs = stmt.executeQuery("select * from creditcard_info where name = 'joe';"); // Delete the encrypted table. int rc5 = stmt.executeUpdate("DROP TABLE IF EXISTS creditcard_info;"); // Delete a CEK.
ResultSet rs = null; rs = stmt.executeQuery("select * from creditcard_info where name = 'joe';"); // Delete the encrypted table. int rc5 = stmt.executeUpdate("DROP TABLE IF EXISTS creditcard_info;"); // Delete a CEK.
Return type: CLOB Example: 1 2 3 4 5 6 -- Create a table. gaussdb=# CREATE TABLE clob_tb(c clob,id int); -- Insert data. gaussdb=# INSERT INTO clob_tb VALUES (empty_clob(),1); -- Delete the table. gaussdb=# DROP TABLE clob_tb; Note: The length is 0 obtained using DBE_LOB.GET_LENGTH
Example: Delete n elements from an array. gaussdb=# declare gaussdb-# type array_integer is varray(10) of integer; gaussdb-# arrint array_integer := array_integer(1,2,3); gaussdb-# begin gaussdb$# dbe_output.print_line(arrint.count); gaussdb$# arrint.trim(1); gaussdb
Return type: BLOB Example: 1 2 3 4 5 6 -- Create a table. gaussdb=# CREATE TABLE blob_tb(b blob,id int); -- Insert data. gaussdb=# INSERT INTO blob_tb VALUES (empty_blob(),1); -- Delete the table. gaussdb=# DROP TABLE blob_tb; Note: The length is 0 obtained using DBE_LOB.GET_LENGTH
ON EXAMPLE1 FOR EACH ROW EXECUTE PROCEDURE FUNCTION_TRI_EXAMPLE2(); CREATE TRIGGER gaussdb=# DELETE FROM EXAMPLE1; DELETE 0 Example 10: Stored procedures that contain IMMUTABLE or SHIPPABLE cannot call COMMIT, ROLLBACK, or another stored procedure that contains COMMIT or ROLLBACK
int TEST_MODE_START_REPL = 2; // Test mode: Delete a logical replication slot. int TEST_MODE_DROP_SLOT = 3; // Enable different test modes.
A positive value indicates that the deletion information of temporary files whose size is larger than the specified value of log_temp_files is recorded. 0 indicates that the delete information of all temporary files is recorded. –1 indicates that the delete information of any temporary
Delete: The index deletion process is added to the UB-tree. The main procedure of index deletion is similar to that of index insertion. That is, obtain the transaction information, fill in the xmax column, and update active_tuple_count on pages.
whether the verified plan is available: t: The verified plan is available. f: The verified plan is unavailable. t/f Return type: Boolean GS_SPM_DELETE_PLAN(sql_hash, plan_hash) Description: GS_SPM_DELETE_PLAN belongs to DBE_SQL_UTIL schema and is a function used by the SPM feature to delete
login password of user jim. gaussdb=# ALTER USER jim IDENTIFIED BY '**********' REPLACE '********'; -- Lock jim. gaussdb=# ALTER USER jim ACCOUNT LOCK; -- Unlock jim. gaussdb=# ALTER USER jim ACCOUNT UNLOCK; -- Change the username. gaussdb=# ALTER USER jim RENAME TO lisa; -- Delete
16408 (2 rows) -- Purge all objects in the recycle bin. gaussdb=# PURGE recyclebin; gaussdb=# SELECT rcyname,rcyoriginname,rcytablespace FROM GS_RECYCLEBIN; rcyname | rcyoriginname | rcytablespace -----------------------+---------------+--------------- (0 rows) -- Delete
salary from hr.staffs where staff_id= :dno; end;' USING OUT first_name, OUT salary, IN staff_id; dbe_output.print_line(first_name|| ' ' || salary); END; / -- Call the stored procedure. gaussdb=# CALL dynamic_proc(); mike 5800.00 dynamic_proc -------------- (1 row) -- Delete
RETURNS SETOF anyelement AS $$ SELECT $1[i][j] FROM generate_subscripts($1,1) g1(i), generate_subscripts($1,2) g2(j); $$ LANGUAGE sql IMMUTABLE; openGauss=# SELECT * FROM unnest2(ARRAY[[1,2],[3,4]]); unnest2 --------- 1 2 3 4 (4 rows) -- Delete
To delete the comment, write NULL at the position of the text string. When an object is deleted, the comment is automatically deleted. Currently, there is no security protection for viewing comments.
RETURNS SETOF anyelement AS $$ SELECT $1[i][j] FROM generate_subscripts($1,1) g1(i), generate_subscripts($1,2) g2(j); $$ LANGUAGE sql IMMUTABLE; openGauss=# SELECT * FROM unnest2(ARRAY[[1,2],[3,4]]); unnest2 --------- 1 2 3 4 (4 rows) -- Delete
RETURNS SETOF anyelement AS $$ SELECT $1[i][j] FROM generate_subscripts($1,1) g1(i), generate_subscripts($1,2) g2(j); $$ LANGUAGE sql IMMUTABLE; gaussdb=# SELECT * FROM unnest2(ARRAY[[1,2],[3,4]]); unnest2 --------- 1 2 3 4 (4 rows) -- Delete
class1:Low"); -- Specify the wg1 Workload Cgroup under the class1 Cgroup. gaussdb=# ALTER RESOURCE POOL pool1 WITH (CONTROL_GROUP="class1:wg1"); -- Specify the wg2 Workload Cgroup under the class1 Cgroup. gaussdb=# ALTER RESOURCE POOL pool1 WITH (CONTROL_GROUP="class1:wg2:3"); -- Delete
