DHBW Datenbanken Unit 1 - 04 - Operatoren

View All Scripts Login to Run Script

Statement 1

CREATE TABLE NUMBERS (
    x    NUMBER,
    name VARCHAR2(30)
)

Table created.

Statement 2

INSERT INTO NUMBERS (x, name) VALUES (1, 'eins')

1 row(s) inserted.

Statement 3

INSERT INTO NUMBERS (x, name) VALUES (2, 'zwei')

1 row(s) inserted.

Statement 4

INSERT INTO NUMBERS (x, name) VALUES (3, 'drei')

1 row(s) inserted.

Statement 5

INSERT INTO NUMBERS (x, name) VALUES (4, 'vier')

1 row(s) inserted.

Statement 6

INSERT INTO NUMBERS (x, name) VALUES (5, 'fünf')

1 row(s) inserted.

Statement 7

INSERT INTO NUMBERS (x, name) VALUES (6, 'sechs')

1 row(s) inserted.

Statement 8

INSERT INTO NUMBERS (x, name) VALUES (7, '')

1 row(s) inserted.

Statement 9

INSERT INTO NUMBERS (x, name) VALUES (8, null)

1 row(s) inserted.

Statement 11

SELECT * FROM NUMBERS


X NAME
1 eins
2 zwei
3 drei
4 vier
5 fünf
6 sechs
7  - 
8  - 

8 rows selected.

Statement 12

SELECT n.x,   
       n.x + 1,  
       n.x - 1,  
       n.x * 2,  
       n.x / 2  
  FROM NUMBERS n


X N.X+1 N.X-1 N.X*2 N.X/2
1 2 0 2 .5
2 3 1 4 1
3 4 2 6 1.5
4 5 3 8 2
5 6 4 10 2.5
6 7 5 12 3
7 8 6 14 3.5
8 9 7 16 4

8 rows selected.

X	N.X+1	N.X-1	N.X*2	N.X/2
1	2	0	2	.5
2	3	1	4	1
3	4	2	6	1.5
4	5	3	8	2
5	6	4	10	2.5
6	7	5	12	3
7	8	6	14	3.5
8	9	7	16	4

Statement 13

SELECT * 
  FROM NUMBERS n
 WHERE n.x = 1


X NAME
1 eins

X	NAME
1	eins

Statement 14

SELECT * 
  FROM NUMBERS n
 WHERE n.x <> 1


X NAME
2 zwei
3 drei
4 vier
5 fünf
6 sechs
7  - 
8  - 

7 rows selected.

Statement 15

SELECT * 
  FROM NUMBERS n
 WHERE n.x > 5


X NAME
6 sechs
7  - 
8  - 

3 rows selected.

Statement 16

SELECT * 
  FROM NUMBERS n
 WHERE n.x >= 5


X NAME
5 fünf
6 sechs
7  - 
8  - 

4 rows selected.

Statement 17

SELECT * 
  FROM NUMBERS n
 WHERE n.x < 3


X NAME
1 eins
2 zwei

2 rows selected.

X	NAME
1	eins
2	zwei

Statement 18

SELECT * 
  FROM NUMBERS n
 WHERE n.x <= 3


X NAME
1 eins
2 zwei
3 drei

3 rows selected.

Statement 19

SELECT * 
  FROM NUMBERS n
 WHERE n.x BETWEEN 2 AND 5


X NAME
2 zwei
3 drei
4 vier
5 fünf

4 rows selected.

Statement 20

SELECT * 
  FROM NUMBERS n
 WHERE n.name LIKE 's%'


X NAME
6 sechs

X	NAME
6	sechs

Statement 21

SELECT * 
  FROM NUMBERS n
 WHERE n.name LIKE '%ei%'


X NAME
1 eins
2 zwei
3 drei

3 rows selected.

Statement 22

SELECT * 
  FROM NUMBERS n
 WHERE n.name LIKE 'dr_i'


X NAME
3 drei

X	NAME
3	drei

Statement 23

SELECT * 
  FROM NUMBERS n
 WHERE n.name LIKE 'dr_i'


X NAME
3 drei

X	NAME
3	drei

Statement 24

SELECT * 
  FROM NUMBERS n
 WHERE n.name LIKE '%'


X NAME
1 eins
2 zwei
3 drei
4 vier
5 fünf
6 sechs

6 rows selected.

Statement 25

SELECT * 
  FROM NUMBERS n
 WHERE n.name IS NULL


X NAME
7  - 
8  - 

2 rows selected.

X	NAME
7	-
8	-

Statement 26

SELECT * 
  FROM NUMBERS n
 WHERE n.name IS NOT NULL


X NAME
1 eins
2 zwei
3 drei
4 vier
5 fünf
6 sechs

6 rows selected.

Additional Information