检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
IF SQL%NOTFOUND THEN DELETE FROM hr.sections_t1 WHERE section_ID = V_DEPTNO; END IF; END; / CALL proc_cursor3(); -- Delete the stored procedure and the temporary table.
IF SQL%NOTFOUND THEN DELETE FROM hr.sections_t1 WHERE section_ID = V_DEPTNO; END IF; END; / CALL proc_cursor3(); -- Delete the stored procedure and the temporary table.
If the department has no employees, delete the department from the hr.sections table. gaussdb=# CREATE OR REPLACE PROCEDURE proc_cursor3() AS DECLARE V_DEPTNO NUMBER(4) := 100; BEGIN DELETE FROM hr.staffs WHERE section_ID = V_DEPTNO; -- Proceed based
Examples 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 -- Delete all employees in a department from the EMP table. If the department has no employees, delete the department from the DEPT table.
Examples 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 -- Delete all employees in a department from the hr.staffs table. If the department has no employees, delete the department from the hr.department table.
If the department has no employees, delete the department from the hr.department table. gaussdb=# CREATE OR REPLACE PROCEDURE proc_cursor3() AS DECLARE V_DEPTNO NUMBER(4) := 100; BEGIN DELETE FROM hr.staffs WHERE section_id = V_DEPTNO; -- Proceed based
-- Delete the view resource label view_for_label. gaussdb=# DROP VIEW view_for_label; -- Delete the schema resource label schema_for_label. gaussdb=# DROP SCHEMA schema_for_label; -- Delete the tb_for_label table. gaussdb=# DROP TABLE tb_for_label; Helpful Links ALTER RESOURCE
Precautions When enable_access_server_directory is set to off, only the initial user is allowed to delete directory objects.
Precautions When enable_access_server_directory is set to off, only the initial user is allowed to delete directory objects.
Precautions When enable_access_server_directory is set to off, only the initial user is allowed to delete directory objects.
You are advised to delete the indexes from the target table before the import. You can create the indexes again after the import is complete. Assume that there is an ordinary index product_idx in the product_id column of the target table product_info.
Adding the CASCADE option can forcibly delete the extension and objects that depend on it. Parent topic: SQL Syntax
This API can only be used to delete a schema at a time. URI DELETE https://{Endpoint}/v3/{project_id}/instances/{instance_id}/schema Table 1 Parameter description Parameter Mandatory Type Description project_id Yes String Explanation: Project ID of a tenant in a region.
Precautions Only the table owner or administrators can delete a row-level security policy from the table.
Precautions Only the table owner or administrators can delete a row-level security policy from the table.
Precautions Only the table owner or administrators can delete a row-level security policy from the table.
the test_clean_connection database. gaussdb=# DROP DATABASE test_clean_connection; -- Delete user jack. gaussdb=# DROP USER jack; Parent topic: C
CLEAN CONNECTION TO ALL FOR DATABASE template1 TO USER jack; -- Delete all connections of user jack. CLEAN CONNECTION TO ALL TO USER jack; -- Clean all the connections to the gaussdb database. CLEAN CONNECTION TO ALL FORCE FOR DATABASE gaussdb; -- Delete user jack.
Precautions In the current version, you cannot delete the procedural language features created, so this syntax cannot be used. Parent topic: D
Precautions In the current version, you cannot delete the procedural language features created, so this syntax cannot be used. Parent topic: D
