Sample LOB table: EMP_PHOTO_RESUME
The LOB sample application uses the EMP_PHOTO_RESUME table. The sample jobs create, load, and manipulate the table.
| Column Name: | EMPNO | EMP_ROWID | PSEG_PHOTO | BMP_PHOTO | RESUME |
|---|---|---|---|---|---|
| Type: | CHAR(6) NOT NULL | ROWID | BLOB(500K) | BLOB(100K) | CLOB(5K) |
| Description: | Employee number | Row identifier | Employee photo (PSEG) | Employee photo (BMP) | Employee resume |
| Values: | 000130 | ##### | Delores M. Quintana | Delores M. Quintana | Delores M. Quintana |
| Values: | 000140 | ##### | Heather A Nicholls | Heather A Nicholls | Heather A Nicholls |
| Values: | 000150 | ##### | Bruce Adamson | Bruce Adamson | Bruce Adamson |
| Values: | 000190 | ##### | James H. Walker | James H. Walker | James H. Walker |