oracle nov12

INSERT INTO departments
               (department_id,department_name,location_id)
VALUES(&department_id,&department_name,&location);



SELECT employee_id,last_name,salary,commission_pct
FROM employees
WHERE job_id LIKE '%REP';


UPDATE employees
SET department_id = 70
WHERE employee_id =113;





UPDATE employees
SET job_id =(SELECT job_id
             FROM employees
             WHERE employees_id = 205),
salary =(SELECT salary
        FROM employees
        WHERE employees_id = 205)
WHERE employee_id = 114;


DELETE FROM employees
WHERE department_id =
     (SELECT department_id
      FROM departments
      WHERE department_name
       LIKE'%Public%');

INSERT INTO
(SELECT employee_id,last_name,
        email,hire_date,job_id,salary,department_id
      FROM employees
      WHERE department_id = 50)
VALUES (99999,'Taylor','DTAYLOR',
        TO_DATE('07-JUN-99', 'DD-MON-RR'),
        'ST_CLERK',5000,50);

INSERT INTO
(SELECT employee_id,last_name,
        email,hire_date,job_id,salary,department_id
      FROM employees
      WHERE department_id = 50);

UPDATE FROM employees
WHERE employee_id =99999;
1 row deleted.
SELECT * FROM
employees
WHERE
employee_id='99999';
INSERT INTO departments
VALUES INTO departments
VALUES (290,'Coporate Tax',NULL,1700);
1 row deleted.



DELETE FROM copy_emp;
22rows deleted.
ROLLBACK;
ROLLBACK compelete.

CREATE TABLE dept
(deptno    NUMBER(2),
dname     VARCHAR2(14),
loc        VARCHAR2(13),
create_date DATE DEFAULT SYSDATE);
Table created.



CREATE TABLE hire_dates
(id            NUMBER(8),
hire_date DATE DEFAULT SYSDATE);
Table created.


CREATE TABLE Pegawai(pgw_id NUMBER(6)
CONSTRAINT pgw_emp_id_pk PRIMARYKEY,
first_name   VARCHAR2(20));

CREATE TABLE Karyawan(kry_id NUMBER(6),
first_name   VARCHAR2(20)),
CONSTRAINT kry_emp_id_pk PRIMARYKEY,
primary key(kry_id));

CREATE TABLE dept80
AS
SELECT employee_id,last_name,
salary*12 ANNSAL,
hire_date
FROM employees
WHERE employees
WHERE department_id = 80;