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 ...
Get Oracle9i™ Development by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.