云数据库 GaussDB-调用语句:示例

时间：2025-02-12 15:05:43

云数据库 GaussDB

示例

  
       --建表gaussdb=# CREATE SCHEMA hr;CREATE SCHEMAgaussdb=# SET CURRENT_SCHEMA = hr;SETgaussdb=# CREATE TABLE staffs (  section_id INTEGER,   salary INTEGER);CREATE TABLEgaussdb=# INSERT INTO staffs VALUES (30, 10);INSERT 0 1gaussdb=# INSERT INTO staffs VALUES (30, 20);INSERT 0 1--创建存储过程proc_staffsgaussdb=# CREATE OR REPLACE PROCEDURE proc_staffs(section     NUMBER(6),salary_sum out NUMBER(8,2),staffs_count out INTEGER)ISBEGINSELECT sum(salary), count(*) INTO salary_sum, staffs_count FROM hr.staffs where section_id = section;END;/CREATE PROCEDURE--创建存储过程proc_return.gaussdb=# CREATE OR REPLACE PROCEDURE proc_returnASv_num NUMBER(8,2);v_sum INTEGER;BEGINproc_staffs(30, v_sum, v_num);  --调用语句dbe_output.print_line(v_sum||'#'||v_num);RETURN;  --返回语句END;/CREATE PROCEDURE--调用存储过程proc_return.gaussdb=# CALL proc_return();30#2.00 proc_return -------------(1 row)--清除存储过程gaussdb=# DROP PROCEDURE proc_staffs;DROP PROCEDUREgaussdb=# DROP PROCEDURE proc_return;DROP PROCEDUREgaussdb=# DROP TABLE staffs;DROP TABLE