检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
proc_control_structure ------------------------ (1 row) -- Delete the stored procedure. gaussdb=# DROP PROCEDURE proc_control_structure; DROP PROCEDURE Parent topic: Control Statements
can periodically execute specific tasks. dbe_sql Advanced function package dbe_sql, which is used to execute dynamic SQL statements and construct query and other commands during application running. dbe_file Advanced function package dbe_file, which is used to read, copy, write, delete
This syntax is supported only when sql_compatibility is set to 'B'. gaussdb=# ALTER SCHEMA ds_new CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; -- Delete user jack and schema ds_new. gaussdb=# DROP SCHEMA ds_new; gaussdb=# DROP USER jack; Helpful Links CREATE SCHEMA and DROP SCHEMA
Syntax Modify a type. 1 ALTER TYPE name action [, ... ]; The clauses corresponding to action are as follows: Add an attribute to a composite type. 1 ADD ATTRIBUTE attribute_name data_type [ COLLATE collation ] [ CASCADE | RESTRICT ] Delete an attribute from a composite type. 1 DROP
(num1 integer, num2 integer) RETURN integer AS BEGIN RETURN num1 + num2; END; / -- Pass by parameter value. gaussdb=# CALL func_add_sql(1, 3); -- Pass by naming tag method. gaussdb=# CALL func_add_sql(num1 => 1,num2 => 3); gaussdb=# CALL func_add_sql(num2 := 2, num1 := 3); -- Delete
new_colname; END; / -- Query data. gaussdb=# SELECT * FROM sections_t1; section | sec_name | manager_id | place_id ---------+--------------+------------+---------- 280 | Info support | 103 | 1400 280 | Info support | 103 | 280 (2 rows) -- Delete
can periodically execute specific tasks. dbe_sql Advanced function package dbe_sql, which is used to execute dynamic SQL statements and construct query and other commands during application running. dbe_file Advanced function package dbe_file, which is used to read, copy, write, delete
For example, you can insert, delete, update, and query data, process SQL statements or scripts, use functions, and generate data. Stable and easy to use Figure 1 shows how an instance is connected.
They are retained until you delete them manually.
The isolation level cannot be changed after data is modified using SELECT, INSERT, DELETE, UPDATE, FETCH, or COPY in the transaction. READ COMMITTED: At this level, a transaction can access only committed data. This is the default level.
For example, you can insert, delete, update, and query data, process SQL statements or scripts, use functions, and generate data. Stable and easy to use Figure 1 shows how an instance is connected.
Example 1: Use the count function for the variable of the nest-table collection type. gaussdb=# declare type nest is table of int; aa nest:=nest(11,22,33,44,55); begin raise info 'count:%' ,aa.count; aa.delete(3); -- Delete an element.
60 61 62 63 64 65 66 67 68 69 -- Create a table. gaussdb=# CREATE TABLE date_type_tab(coll date); -- Insert data. gaussdb=# INSERT INTO date_type_tab VALUES (date '12-10-2010'); -- View data. gaussdb=# SELECT * FROM date_type_tab; coll ------------ 2010-12-10 (1 row) -- Delete
SQL execution: JDBC can be used to query, update, and delete SQL statements. This is achieved by constructing SQL statements in Java code and sending them to the database.
SQL execution: JDBC can be used to query, update, and delete SQL statements. This is achieved by constructing SQL statements in Java code and sending them to the database.
SQL execution: JDBC can be used to query, update, and delete SQL statements. This is achieved by constructing SQL statements in Java code and sending them to the database.
the tpcds.customer_address table. gaussdb=# DROP TABLE tpcds.customer_address; -- Delete a schema. gaussdb=# DROP SCHEMA tpcds CASCADE; Helpful Links CLOSE and MOVE Parent topic: SQL Syntax
SQL execution: JDBC can be used to query, update, and delete SQL statements. This is achieved by constructing SQL statements in Java code and sending them to the database.
V_EMPNO, V_SAL; EXIT WHEN C%NOTFOUND; IF V_SAL<=3000 THEN UPDATE hr.staffs_t1 SET salary =salary + 500 WHERE staff_id = V_EMPNO; END IF; END LOOP; CLOSE C; END; / CREATE PROCEDURE CALL cursor_proc2(); cursor_proc2 -------------- (1 row) -- Delete
REVOKE [ GRANT OPTION FOR ] { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | ALTER | DROP | COMMENT | INDEX | VACUUM }[, ...] | ALL [ PRIVILEGES ] } ON { [ TABLE ] table_name [, ...
