检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
For example, delete the partition date_202005 from the range partitioned table range_sales by specifying the partition name and update the global index.
DBE_PLDEBUGGER.delete_breakpoint During debugging on the debug end, call delete_breakpoint to delete the existing breakpoint.
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.
Locate a stopped DR task and click Delete in the Operation column. In the displayed dialog box, confirm the information and click Yes. Parent Topic: Disaster Recovery Management
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).
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 -- 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 -- 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 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
Precautions When enable_access_server_directory is set to off, only the initial user is allowed to delete directory objects.
