Diese Ausgabe widmet sich dem DevOps. Lesen Sie spannende Beiträge zum Thema von Oliver Lemm, Stefan Kühnlein, Mario Herb und weiteren Experten. Weiterhin erhalten Sie in dieser Ausgabe Informationen zu den Themen Entwicklung und Exadata sowie aktuelle Neuigkeiten.
Wir wünschen Ihnen viel Spaß beim Lesen! »Zum Download
Listings:
SELECT *
FROM emp_by_dept
WHERE deptno = 10;
deptno | hiredate | empno | ename
10 | 1981-11-17 07:00:00+0000 | 7839 | KING
10 | 1981-06-09 07:00:00+0000 | 7782 | CLARK
Listing 11
SELECT *
FROM emp_by_dept
WHERE deptno = 10
ORDER BY ename;
InvalidRequest: Error from server: code=2200 [Invalid query] message="Order by is currently only supported on the clustered columns of the PRIMARY KEY, got ename"
Listing 12
SELECT *
FROM emp_by_dept
WHERE deptno = 10
AND hiredate > '1900-01-01'
AND hiredate < '2000-01-01';
deptno | hiredate | empno | ename
10 | 1981-06-09 07:00:00+0000 | 7782 | CLARK
10 | 1981-11-17 07:00:00+0000 | 7839 | KING
Listing 13
INSERT INTO emp (empno, ename, job, mgr, hiredate, sal, comm, deptno)
VALUES( 9000, 'OTT', 'DEVELOPER', null, '2000-01-01', 5000, null, 10);
SELECT empno, ename, sal FROM emp WHERE empno = 9000;
empno | ename | sal
9000 | OTT | 5000
Listing 14
INSERT INTO emp (empno, ename, job, mgr, hiredate, sal, comm, deptno)
VALUES( 9000, 'OTT', 'DEVELOPER', null, '2000-01-01', 6000, null, 10);
SELECT empno, ename, sal FROM emp WHERE empno = 9000;
empno | ename | sal
9000 | OTT | 6000
Listing 15
UPDATE emp SET sal = 9000 WHERE empno = 9001;
SELECT empno, ename, sal FROM emp WHERE empno = 9001;
empno | ename | sal
9001 | null | 9000
Listing 16
UPDATE emp SET sal = 7000 WHERE ename = 'OTT';
InvalidRequest: Error from server: code=2200 [Invalid query] message="Some partition key parts are missing: empno"
DELETE FROM emp WHERE empno = 9000;
SELECT empno, ename, sal FROM emp WHERE empno = 9000;
empno | ename | sal
Listing 17
