APUNTES U1.txt - -DDL CREATE TABLE job_grades(GRAVE_LEVEL...

This preview shows page 1 - 2 out of 2 pages.

--------------------------------------- DDL----------------------------------------------------- CREATE TABLE job_grades (GRAVE_LEVEL VARCHAR2(3),LOWER_SAL NUMBER ,HIGHESTE_SAL NUMBER ); DROP TABLE job_grades; DESCRIBE job_grades; CREATE OR REPLACE VIEW CopiaEmpleados (id,nombre,apellido,contrata,salario) AS SELECT employee_id,first_name,last_name,hire_date,salary FROM Employees; Where----- CREATE INDEX Emp_salario_ix ON Employees(last_name,first_name,salary); CREATE SYNONYM Esx FOR Emp_salario_ix; SELECT * FROM E; //------------------------------------ DML---------------------------------------------------- INSERT UPDATE DELETE CREATE TABLE Personal (employees_id NUMBER(6) PRIMARY KEY, last_name VARCHAR(25) NOT NULL, salary NUMBER(8,2) , commission_pct NUMBER (2,2)); INSERT INTO PERSONAL SELECT employee_id,last_name,salary,commission_pct FROM Employees; Insert INTO pruba Select * from cuenta where nombre_sucursal=''; ------------------Modificacion de datos------------------------------------- UPDATE employees SET first_name='Yusei' WHERE employee_id=207; INSERT INTO employees (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,Hire_date,JOB_ID)

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture