DHBW Datenbanken Unit 1 - 03 - AND, NOT und OR

View All Scripts Login to Run Script

Statement 1

CREATE TABLE CONTACTS (
    NAME    VARCHAR2(255),
    SURNAME VARCHAR2(255),
    CITY    VARCHAR2(255),
    COUNTRY VARCHAR2(255)
)

Table created.

Statement 2

INSERT INTO CONTACTS (NAME, SURNAME, CITY, COUNTRY) VALUES ('Bond', 'Peter', 'London', 'UK')

1 row(s) inserted.

Statement 3

INSERT INTO CONTACTS (NAME, SURNAME, CITY, COUNTRY) VALUES ('Ford', 'Tom', 'New York', 'US')

1 row(s) inserted.

Statement 4

INSERT INTO CONTACTS (NAME, SURNAME, CITY, COUNTRY) VALUES ('Cotillard', 'Marion', 'Paris', 'FR')

1 row(s) inserted.

Statement 5

INSERT INTO CONTACTS (NAME, SURNAME, CITY, COUNTRY) VALUES ('Woll', 'Felicitas', 'Berlin', 'DE')

1 row(s) inserted.

Statement 7

SELECT *
  FROM CONTACTS c
 WHERE c.name    = 'Bond'
   AND c.country = 'UK'


NAME SURNAME CITY COUNTRY
Bond Peter London UK

NAME	SURNAME	CITY	COUNTRY
Bond	Peter	London	UK

Statement 8

SELECT *
  FROM CONTACTS c
 WHERE c.name    = 'Bond'
   AND c.country = 'DE'

no data found

Statement 9

SELECT *
  FROM CONTACTS c
 WHERE c.name    = 'Bond'
    OR c.country = 'DE'


NAME SURNAME CITY COUNTRY
Bond Peter London UK
Woll Felicitas Berlin DE

2 rows selected.

NAME	SURNAME	CITY	COUNTRY
Bond	Peter	London	UK
Woll	Felicitas	Berlin	DE

Statement 10

SELECT *
  FROM CONTACTS c
 WHERE c.name    = 'XXX'
    OR c.country = 'zz'

no data found

Statement 11

SELECT *
  FROM CONTACTS c
WHERE NOT (c.name = 'Bond')


NAME SURNAME CITY COUNTRY
Ford Tom New York US
Cotillard Marion Paris FR
Woll Felicitas Berlin DE

3 rows selected.

NAME	SURNAME	CITY	COUNTRY
Ford	Tom	New York	US
Cotillard	Marion	Paris	FR
Woll	Felicitas	Berlin	DE

Additional Information