Using Sequences and Inserting Data into View Ridge

1
Using Sequences and Inserting Data into View Ridge

• Oracle Lab 2

2
Create a Customer Surrogate ID in SQLPlus by
typingCreate Sequence CustID Increment by 1
Start with 1000Then, press Enter.
3
CustID Sequence is created
4
Create an Artist Surrogate ID in SQLPlus by
typingCreate Sequence ArtistID Increment by 1
Start with 1Then, press Enter.
5
Create a Work Surrogate ID in SQLPlus by
typingCreate Sequence WorkId Increment by 1
Start with 500Then, press Enter.
6
Create a Transaction Surrogate ID in SQLPlus by
typingCreate Sequence TranID Increment by 1
Start with 100Then, press Enter.
7
All Sequences have been created
8
Enter the data into View Ridge tables.
Typestart VRGData and press Enter.
9
Create a spool file of the statements that will
be assigned

• Click File, Spool, Spool File

10
Type OracleLab2 for the file name, click Save
11
Demonstrate the data in the tables by typing
these commands Enter.

• Select CustomerID, Name from Customer
• Select ArtistID, Name from Artist

12
Click File, Spool, Spool Off
13
Open OracleLab2 in Notepad print it out.
14
Type your name at the top, then Click File,
Print. Turn in the code.