<commit_before>---
title: Oracle 1.7 Isolation Level
layout: report
date: 2016-12-02
taskHref: http://griesmayer.com/?menu=Oracle&semester=Semester_3&topic=07_IsolationLevel
description: Erfüllung der Aufgabenstellung
subject: dbi
---

# Isolation Level

Team Members
- Juri "<NAME>" Schreib
- Jia-Jun "JJ" Zhang

##Create Tables using the SQl Devleoper

Tables -> Create Table...

**Note:** *Make sure to select a User that can create tables.*

**Note:** *Check the Advanced Checkbox to set foreign key constrains and "advanced" data types such as int*

### Customer

![](20161204_728x535.png)

```sql
CREATE TABLE schreib.CUSTOMER
(
  CUSTOMER_ID INT NOT NULL
, FIRST_NAME VARCHAR(20)
, CREDIT DECIMAL(10, 2)
, CONSTRAINT CUSTOMER_PK PRIMARY KEY
  (
    CUSTOMER_ID
  )
  ENABLE
)
```

### Product

We reuse the Product table from the last lesson

```sql
CREATE TABLE schreib.product
(
product_id INTEGER PRIMARY KEY,
product_name VARCHAR2(20),
product_price DECIMAL(10,2)
);
```

### Stock
**Note:** *Remember to Add the foreign key constrians*

![](20161204_679x160.png)

### Sales

![](20161204_614x106.png)




## Insert statements for the Product Table

```sql
insert into schreib.product values
(1, 'Schnitzel', 6.9);
insert into schreib.product values
(2, 'Pizza', 5.9);
insert into schreib.product values
(3, 'Nudel', 6.5);
insert into schreib.product values
(4, 'Sushi', 8.9);
insert into schreib.product values
(5, 'Spetzle', 9.9);
insert into schreib.product values
(6, 'Bacon', 8.9);
insert into schreib.product values
(7, 'Banane', 3.9);
insert into schreib.product values
(8, 'Apfel', 2.9);
insert into schreib.product values
(9, 'Durchfall', 99.9);
insert into schreib.product values
(10, 'Birne', 1.9);
```

![](20161204_408x245.png)

## Create User Zhang

*The process of user creation is documented in* [6_Rights](06_Rights)

# Test the commands

As long as no commit statement is executed, no changees are visible for the other user.

*Like last time, unneccesary to document, since we're already late for this one*
<commit_msg>Updated Link<commit_after>---
title: Oracle 1.7 Isolation Level
layout: report
date: 2016-12-02
taskHref: http://griesmayer.com/?menu=Oracle&semester=Semester_3&topic=07_IsolationLevel
description: Erfüllung der Aufgabenstellung
subject: dbi
---

# Isolation Level

Team Members
- Juri "<NAME>" Schreib
- Jia-Jun "JJ" Zhang

##Create Tables using the SQl Devleoper

Tables -> Create Table...

**Note:** *Make sure to select a User that can create tables.*

**Note:** *Check the Advanced Checkbox to set foreign key constrains and "advanced" data types such as int*

### Customer

![](20161204_728x535.png)

```sql
CREATE TABLE schreib.CUSTOMER
(
  CUSTOMER_ID INT NOT NULL
, FIRST_NAME VARCHAR(20)
, CREDIT DECIMAL(10, 2)
, CONSTRAINT CUSTOMER_PK PRIMARY KEY
  (
    CUSTOMER_ID
  )
  ENABLE
)
```

### Product

We reuse the Product table from the last lesson

```sql
CREATE TABLE schreib.product
(
product_id INTEGER PRIMARY KEY,
product_name VARCHAR2(20),
product_price DECIMAL(10,2)
);
```

### Stock
**Note:** *Remember to Add the foreign key constrians*

![](20161204_679x160.png)

### Sales

![](20161204_614x106.png)




## Insert statements for the Product Table

```sql
insert into schreib.product values
(1, 'Schnitzel', 6.9);
insert into schreib.product values
(2, 'Pizza', 5.9);
insert into schreib.product values
(3, 'Nudel', 6.5);
insert into schreib.product values
(4, 'Sushi', 8.9);
insert into schreib.product values
(5, 'Spetzle', 9.9);
insert into schreib.product values
(6, 'Bacon', 8.9);
insert into schreib.product values
(7, 'Banane', 3.9);
insert into schreib.product values
(8, 'Apfel', 2.9);
insert into schreib.product values
(9, 'Durchfall', 99.9);
insert into schreib.product values
(10, 'Birne', 1.9);
```

![](20161204_408x245.png)

## Create User Zhang

*The process of user creation is documented in* [6_Rights](../06_Rights)

# Test the commands

As long as no commit statement is executed, no changees are visible for the other user.

*Like last time, unneccesary to document, since we're already late for this one*

{'fraction_non_alphanumeric': 0.12560975609756098, 'fraction_numerical': 0.05609756097560976, 'mean_word_length': 4.767932489451477, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 7, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5191336', 'n_tokens_mistral': 1619, 'n_tokens_neox': 1438, 'n_words': 485}