SECTION 8

lesson 2
1.1 create o_employees
as (select* from employees)
1.2 create o_departments
as (select * from departments)
1.2 create o_jobs
as (select * from jobs)

2.insert into o_jobs(id,job_title,job_id,max_salary,min_salary)
values(210,’Human Resources Mamager’,'HR_MAN’,5500,4500)

3.insert into o_employees
(emoloyee_id,first_name,last_name,email_address,hire_date)
values(210,’Ramon’,'Sanchez’,'RSANCHEZ’,sysdate)

4.insert into o_employees
select (emoloyee_id,first_name,last_name,email_address,hire_date)
values(210,’Ramon’,'Sanchez’,'RSANCHEZ’,sysdate)

lesson 4

2.create table grad_candidates
(student_id number(6),last_name varchar2(10), first_name varchar2(15),credits number (3), graduation_date date (8), constraint Graduate_Candidates_primary_key PRIMARY KEY(student_id));

3.despribe grad_candidates

4.update smith_table
as(select *
from grad_candidates);

5.select*
from USER_TABLES
select *
from USER_OBJECTS
select *
from USER_CATALOG or USER_CAT

6.insert into smith_table
values(…………………………….)

lesson 5