字段名 数据类型 是否可空 约束 备注v_id number10 N 主键 会员号l_id number10 外键引用levelss表的l_id字段 等级号v_name Varchar210 姓名v_sex varchar22 必须为‘男’或‘女’ 性别v_age number3 年龄v_job varchar220 工作单位v_tel number11 电话号码v_addre

CREATE VIEW member_info AS SELECT v_id, v_name, v_sex, v_age, v_job, v_tel, v_address, v_number, v_birthday, l_name FROM members INNER JOIN levels ON members.l_id = levels.l_id;