1.create view vw_Studentinf as select 学号,姓名,性别,班级编号,部门编号 from 学生信息表;2.create index idx_className on 班级信息表 (班级名称);1.create or replace procedure up_getDetail asv_ename varchar2(5);v_id varchar2(5);v_sex varchar2(5);v_age number(5);v_adress varchar2(5);beginselect ename,id,sex,age,adress into v_ename from emp wh |