Membuat dan mengelola Tabel dengan Data Definition Language(DDL)
beberapa obyek basis data yang terdapat dalam oracle dalah table,view,dan index.Tabel adalah unit simpan dasar,terdiri atas baris dan kolom.sedangkan view merupakan subset dari salah satu atau lebih tabel.dibawah ini merupakan cara membuat dan mengelola tabel.

--1
create table DEPT1
  (id   number(7)
      CONSTRAINT dep_id_pk PRIMARY KEY
      CONSTRAINT dep_id_nn NOT NULL
  ,NAME VARCHAR2(25)
      CONSTRAINT dep_name_nn NOT NULL);

--2
INSERT INTO dept1
values (10, 'Marketing');

select *
from dept1;

select department_name, department_id
from departments; --ini diisi apa?

--3
CREATE TABLE EMP1
  (id NUMBER(7)
      constraint emp1_id_pk PRIMARY KEY
  ,last_name VARCHAR2(25)
  ,first_name VARCHAR2(26)
  ,dept_id NUMBER(7)
  CONSTRAINT emp1_id_fk REFERENCES DEPT1(id));

select *
from emp1;

--4
alter table emp1
modify (first_name VARCHAR2(50));
--5
desc employees;

CREATE TABLE EMP2
  (id NUMBER(6)
    constraint emp2_id_pk PRIMARY KEY
    constraint emp2_id_nn NOT NULL
  ,first_name VARCHAR2(20)
  ,last_name VARCHAR2(25)
    constraint emp2_last_name_nn NOT NULL
  ,salary NUMBER(8,2)
  ,dept_id NUMBER(4)); -- ini gimana liat foreign key nya?

--6
drop table dept1; --ini bener gak bisa dihapus langsung?

--7
rename emp2 to staff;

--8
alter table staff
drop column first_name;

--9
CREATE TABLE employees2 (
employee_id NUMBER(6)
CONSTRAINT emp3_id_pk PRIMARY KEY
,first_name VARCHAR2(20)
,last_name VARCHAR2(25)
CONSTRAINT emp3_last_name_nn NOT NULL
,email VARCHAR2(25)
CONSTRAINT emp3_email_nn NOT NULL
CONSTRAINT emp3_email_uk UNIQUE
,phone_number VARCHAR2(20)
,hire_date DATE
CONSTRAINT emp3_hire_date_nn NOT NULL
,job_id VARCHAR2(10)
CONSTRAINT emp3_job_nn NOT NULL
,salary NUMBER(8,2)
CONSTRAINT emp3_salary_ck CHECK (salary>0)
,commission_pct NUMBER(2,2)
,manager_id NUMBER(6)
,department_id NUMBER(4)
CONSTRAINT emp3_dept_fk REFERENCES
departments(department_id));

--10
create table departments2(
department_id NUMBER(10)
  constraint dep1_id_pk PRIMARY KEY
  constraint dep1_id_nn NOT NULL
,department_name VARCHAR2(30)
  constraint dep1_name_nn NOT NULL
,manager_id NUMBER(10)
  constraint dep1_man_fk REFERENCES
  EMPLOYEES2(employee_id)
  constraint dep1_man_nn NOT NULL
,location_id NUMBER(10)
  constraint dep1_loc_nn NOT NULL);
 
--11
drop table EMPLOYEES2;

--12
drop table departments2;

--13
drop table EMPLOYEES2;