检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
DBE_PLDEBUGGER.delete_breakpoint During debugging on the debug end, call delete_breakpoint to delete the existing breakpoint.
statements (unit: μs). max_delete_elapse bigint Maximum response time of DELETE statements (unit: μs). min_delete_elapse bigint Minimum response time of DELETE statements (unit: μs). avg_delete_elapse bigint Average response time of DELETE statements (unit: μs).
statements (unit: μs). max_delete_elapse bigint Maximum response time of DELETE statements (unit: μs). min_delete_elapse bigint Minimum response time of DELETE statements (unit: μs). avg_delete_elapse bigint Average response time of DELETE statements (unit: μs).
Precautions When enable_access_server_directory is set to off, only the initial user is allowed to delete the directory object.
Precautions When enable_access_server_directory is set to off, only the initial user is allowed to delete the directory object.
Precautions When enable_access_server_directory is set to off, only the initial user is allowed to delete the directory object.
Precautions When enable_access_server_directory is set to off, only the initial user is allowed to delete the directory object.
DBE_PLDEBUGGER.delete_breakpoint During debugging on the debug end, call delete_breakpoint to delete the existing breakpoint, as described in Table 1.
DBE_PLDEBUGGER.delete_breakpoint During debugging on the debug end, call delete_breakpoint to delete the existing breakpoint, as described in Table 1.
statements (unit: μs). max_delete_elapse bigint Maximum response time of DELETE statements (unit: μs). min_delete_elapse bigint Minimum response time of DELETE statements (unit: μs). avg_delete_elapse bigint Average response time of DELETE statements (unit: μs).
Examples 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 -- Delete all employees in a department from the hr.staffs table. If the department has no employees, delete the department from the hr.sections table.
Examples 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 -- Delete all employees in a department from the hr.staffs table. If the department has no employees, delete the department from the hr.sections 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.
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.
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.
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
-- 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
statements (unit: μs). max_delete_elapse bigint Maximum response time of DELETE statements (unit: μs). min_delete_elapse bigint Minimum response time of DELETE statements (unit: μs). avg_delete_elapse bigint Average response time of DELETE statements (unit: μs).
Precautions When enable_access_server_directory is set to off, only the initial user is allowed to delete directory objects.