dkfr.net
当前位置:首页 >> NETEZZA 开发语法如:存储过程 >>

NETEZZA 开发语法如:存储过程

CREATE OR REPLACE PROCEDURE pro_1(CHARACTER VARYING(10)) RETURNS VARCHAR(ANY) EXECUTE AS OWNER LANGUAGE NZPLSQL AS BEGIN_PROC DECLARE jqid_cursor record; BEGIN -- procedure body FOR jqid_cursor for select f_jqid from t_scenicda...

CREATE PROCEDURE order_tot_amt @o_id int, @p_tot int output AS SELECT @p_tot = sum(Unitprice*Quantity) FROM orderdetails WHERE ordered=@o_id GO 例子说明: 该例子是建立一个简单的存储过程order_tot_amt,这个存储过程根据用户输入的定...

网站首页 | 网站地图
All rights reserved Powered by www.dkfr.net
copyright ©right 2010-2021。
内容来自网络,如有侵犯请联系客服。zhit325@qq.com