- --存储过程
- CREATE OR REPLACE PROCEDURE insert_student
- as
- student_id number;
- student_name varchar2(20);
- student_sex varchar2(20);
- student_age number;
- student_department varchar2(20);
- begin
- --给多个变量赋值
- select name,sex into student_name,student_sex from student where studentid = 1;
- db
- end insert_student;
存储过程 参数定义 赋值方法select into
最新推荐文章于 2024-06-03 10:36:37 发布