DHBW Datenbanken Unit 1 - 01 - SQL im Schnelldurchlauf

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 4

SELECT *
  FROM CONTACTS


NAME SURNAME CITY COUNTRY
Bond Peter London UK

NAME	SURNAME	CITY	COUNTRY
Bond	Peter	London	UK

Statement 5

UPDATE CONTACTS
   SET surname = 'James'

1 row(s) updated.

Statement 6

SELECT * FROM CONTACTS


NAME SURNAME CITY COUNTRY
Bond James London UK

NAME	SURNAME	CITY	COUNTRY
Bond	James	London	UK

Statement 10

SELECT * FROM CONTACTS


NAME SURNAME CITY COUNTRY
Bond Peter London UK

NAME	SURNAME	CITY	COUNTRY
Bond	Peter	London	UK

Additional Information