Oracle

Practice #9


Overview


• Inserting rows into the tables
• Updating and deleting rows in the table
• Controlling transactions





Development


1. Build theMY_EMPLOYEE table that will be used for the lab and describe the structure of the MY_EMPLOYEE table to identify the column names.
[pic]

Name Null? Type
--------------------- ------
ID NOT NULL NUMBER(4)
LAST_NAME VARCHAR2(25)
FIRST_NAME VARCHAR2(25)
USERID VARCHAR2(8)SALARY NUMBER(9,2)


2. Add the first row of data to the MY_EMPLOYEE table from the following sample data This time, list the columns explicitly in the INSERT clause..[pic]


ID LAST_NAME FIRST_NAME USERID SALARY
--- ----------- ---------- ------ ------
1 Patel Ralph rpatel 795
2 Dancs Bettybdancs 860


3. Confirm your addition to the table.
[pic]
ID LAST_NAME FIRST_NAME USERID SALARY
--- ----------- ---------- ------ ------
1 PatelRalph rpatel 795
2 Dancs Betty bdancs 860


4. Add the first row of data to the MY_EMPLOYEE table from the following sample data This time, list the columnsimplicitly in the INSERT clause.
[pic]
ID LAST_NAME FIRST_NAME USERID SALARY
--- ----------- ---------- ------ ------
3 Biri Ben bbiri 1100
4Newman Chad cnewman 750



5. Confirm your additions to the table.
[pic]
ID LAST_NAME FIRST_NAME USERID SALARY
--- ---------- ---------- ------ ------
1 PatelRalph rpatel 795
2 Dancs Betty bdancs 860
3 Biri Ben bbiri 1100
4 Newman Chad cnewman 750


6. Make the data additions...