Data used for the sample projects are contained within a table called db_employee. The table has three columns, as follows:
Table 1 Sample Project Data - db_employee Table
Column Name |
Data Type |
Data Length |
---|---|---|
emp_no |
INTEGER |
10 |
last_name |
VARCHAR |
30 |
first_name |
VARCHAR |
30 |
rate |
FLOAT |
15 |
last_update |
TIMESTAMP |
19 |
Oracle databases do not accept table data with columns that include Boolean data types. For example, an Oracle server expects a literal “T” or “F” for True or False Boolean values, and does not accept Java primitive Boolean True or False values.