17.04.2017 Andmebaasirakenduste arendaja x3

Kordasime SQL lauseid.

Näide:

SELECT FIRST_NAME||' '||LAST_NAME Nimi, PHONE_NUMBER Telefon FROM EMPLOYEES WHERE SUBSTR(PHONE_NUMBER,1,1) LIKE '5' or SUBSTR(PHONE_NUMBER,1,1) LIKE '8' or SUBSTR(PHONE_NUMBER,1,1) LIKE '2' or SUBSTR(PHONE_NUMBER, -1) LIKE '5' or SUBSTR(PHONE_NUMBER, -1) LIKE '8' or SUBSTR(PHONE_NUMBER, -1) LIKE '2';

Valib ees-, perenime ja numbri nendel isikutel kelle number algav või lõppeb numbritega 2, 5 või 8

CREATE TABLE AH_emp (id NUMBER(4) CONSTRAINT ah_emp_id_pk PRIMARY KEY, nimi VARCHAR2(40), email VARCHAR2(100), amet CHAR(8), osak_id NUMBER(4), CONSTRAINT ah_emp_osak_id_fk FOREIGN KEY (osak_id) REFERENCES AH_dept(id));

Loob tabeli kus.....


insert into ah_dept (DEPTNO,DNAME,LOC,CREATE_DATE) values (1, 'Test', 'dunno', current_date);

Lisab kirje tabelisse ah_dept