oracle定义变量以及变量的使用
DECLARExiaoyi VARCHAR2 (50) ;BEGINxiaoyi := 'xiaoyiid' ;FOR item IN (SELECT*FROMUSER uWHEREu.id = xiaoyi) LOOPdbms_output.put_line (u.id) ;END LOOP ;END ;...
·
DECLARE
xiaoyi VARCHAR2 (50) ;
BEGIN
xiaoyi := 'xiaoyiid' ;
FOR item IN (
SELECT
*
FROM
USER u
WHERE
u.id = xiaoyi
) LOOP
dbms_output.put_line (u.id) ;
END LOOP ;
END ;
更多推荐
已为社区贡献3条内容
所有评论(0)