摘要： 1）创建一个用户名称为user1并授予权限至少能够访问hr.employees（不能授予dba权限） SYS@ORA11GR2>create user user1 identified by user1; User created. SYS@ORA11GR2>grant create session,create table,create sequence,create view to use... 阅读全文

摘要： 1)显示正好为5个字符的员工的姓名 HR@ORA11GR2>select last_name,first_name from employees 2 where length(first_name) = 5; 2)显示不带有"R"的员工的姓名. HR@ORA11GR2>select last_name,first_name from employees 2 where first_... 阅读全文