新手求指导，关于oracle数据绑定的问题,刚入手数据库，请高手门说得简单清晰一些，谢谢了！原代码如下：
SQL代码：
declare
dep_name department.department_name%type;
begin
select department_name into dep_name from department where department_id=2;
end;
表：
SQL> select * from department;
DEPARTMENT_ID DEPARTMENT_NAME MANGER_ID LOCATION_ID
------------- -------------------- --------- -----------
2 设计部
SQL>
刚入手看到这条select into 的命令，请指教！
------解决方案--------------------
declare
dep_NAME student.NAME %type;
begin
select NAME into dep_NAME from student where ID =1;
end;
如果id不是唯一的话……
declare
dep_NAME student.NAME %type;
begin
select max(NAME) into dep_NAME from student where ID =1;
end;