El Ultimo Vestijio

1. select employee_id, first_name from employees where upper(first_name) like '%R%'; 2. select employee_id, first_name, job_id, department_id from employees order by job_id, department_id ; 3. select employee_id, first_name, job_id, comission_pct from employees where comission_pct is null; 4. select first_name from employees where upper(first_name) like '_L%'; 5. select distinct job_id from jobs; 6.1 select first_name, job_id from employees where department_id in (10,60); 6.2 select first_name, job_id from employees where department_id like 10 or department_id like 60; 7. select first_name, comission_pct from employees where comission_pct > 0.3; 8. select first_name, salary, department_id from employees where department_id=50 order by salary desc; 9. select first_name from employees where first_name like '____'; 10. select first_name, job_id from employees where employee_id in (148,149) order by first_na

si se desea trabajar con las tablas de HR de oracle pero sin modificarlas, los siguientes pasos son para crear dichas tablas en copia y poder trabajar con ellas sin ningun problema. create table "nombredelatabla" as select * from hr."nombredelatabla" ejemplo: create table employees as select * from hr.employees; esto aplica para cada una de las tablas que se deseen copiar a cada uno de los usuarios que se vayan creando dentro de la aplicacion.