Live SQL

DHBW Datenbanken Unit 1 - 01 - SQL im Schnelldurchlauf

View All Scripts Login to Run Script

Script Name DHBW Datenbanken Unit 1 - 01 - SQL im Schnelldurchlauf
Description DHBW Datenbanken Unit 1
Area SQL General
Contributor Matthias K. F. Schulz
Created Thursday September 15, 2016

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
```
COMMIT
```
Statement processed.
Statement 4
```
SELECT *
  FROM CONTACTS
```
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
Statement 7
```
DELETE FROM CONTACTS
```
1 row(s) deleted.
Statement 8
```
SELECT * FROM CONTACTS
```
no data found
Statement 9
```
ROLLBACK
```
Statement processed.
Statement 10
```
SELECT * FROM CONTACTS
```
NAME SURNAME CITY COUNTRY
Bond Peter London UK

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database