Oracle9i™ Development by Example

Applying It

Independent Exercise 1:

• Create a Table called people with columns of dept (numeric 4 positions), last_name (character 10 positions), start_date (date field), and salary (numeric 5 positions with 2 decimal positions).

Independent Exercise 2:

• Insert the following data into the table, try out the & substitution character:

  • Dept 10, SMITH, SYSDATE, 10000

  • Dept 10, JONES, SYSDATE, 20000

  • Dept 20, KING, SYSDATE, 15000

  • Dept 20, JONES, SYSDATE, 18000

  • Dept 20, FOUNTAIN, SYSDATE, 12000

Independent Exercise 3:

• Select those rows from Dept 20.
• Select name and start_date with the start_date in the format of MM/DD/YYYY.
• Give everyone in dept 10 a 10% increase ...