DHBW Datenbanken Unit 1 - 02 - SQL Languages

Statement1

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

Table created.

Statement2

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

1 row(s) inserted.

Statement3

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

1 row(s) inserted.

Statement4

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

1 row(s) inserted.

Statement5

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

1 row(s) inserted.

Statement6

COMMIT

Statement processed.

Statement7

SELECT *
  FROM CONTACTS

Statement8

SELECT c.name, c.city
  FROM CONTACTS c

Statement9

SELECT c.city AS "Stadt" 
  FROM CONTACTS c

Statement10

SELECT * 
  FROM CONTACTS c 
 WHERE c.country = 'UK'

Statement11

   SELECT c.country 
     FROM CONTACTS c 
 ORDER BY c.country ASC

Statement12

   SELECT c.country 
     FROM CONTACTS c 
 ORDER BY c.country DESC

Statement13

 SELECT count(*)
  FROM CONTACTS

Statement14

DELETE FROM CONTACTS

4 row(s) deleted.

Statement15

SELECT * FROM CONTACTS

no data found

Statement16

ROLLBACK

Statement processed.

Statement17

SELECT * FROM CONTACTS

Statement18

DELETE FROM CONTACTS c 
 WHERE c.name = 'Bond'

1 row(s) deleted.

Statement19

SELECT * FROM CONTACTS

Statement20

UPDATE CONTACTS
   SET surname = 'James'

3 row(s) updated.

Statement21

SELECT * FROM CONTACTS

Statement22

ROLLBACK

Statement processed.

Statement23

SELECT * FROM CONTACTS

Statement24

UPDATE CONTACTS c 
   SET surname = 'James' 
 WHERE c.country = 'UK'

1 row(s) updated.

Statement25

SELECT * FROM CONTACTS