SQL Reference

Sample Files with BLOB and CLOB Data Type

This section shows the data found in the EMP_PHOTO files (pictures of employees) and EMP_RESUME files (resumes of employees).

Quintana Photo

Figure 13. Delores M. Quintana

_ sqlx0qin pseg38pp

Quintana Resume

The following text is found in the db200130.asc and db200130.scr files.

Resume: Delores M. Quintana

 

Personal Information

Address:
1150 Eglinton Ave Mellonville, Idaho 83725
Phone:
(208) 555-9933
Birthdate:
September 15, 1925
Sex:
Female
Marital Status:
Married
Height:
5'2"
Weight:
120 lbs.

Department Information

Employee Number:
000130
Dept Number:
C01
Manager:
Sally Kwan
Position:
Analyst
Phone:
(208) 555-4578
Hire Date:
1971-07-28

Education

1965
Math and English, B.A. Adelphi University

1960
Dental Technician Florida Institute of Technology

Work History

10/91 - present
Advisory Systems Analyst Producing documentation tools for engineering department.

12/85 - 9/91
Technical Writer Writer, text programmer, and planner.

1/79 - 11/85
COBOL Payroll Programmer Writing payroll programs for a diesel fuel company.

Interests

Nicholls Photo

Figure 14. Heather A. Nicholls

_ sqlx0nic pseg38pp

Nicholls Resume

The following text is found in the db200140.asc and db200140.scr files.

Resume: Heather A. Nicholls

 

Personal Information

Address:
844 Don Mills Ave Mellonville, Idaho 83734
Phone:
(208) 555-2310
Birthdate:
January 19, 1946
Sex:
Female
Marital Status:
Single
Height:
5'8"
Weight:
130 lbs.

Department Information

Employee Number:
000140
Dept Number:
C01
Manager:
Sally Kwan
Position:
Analyst
Phone:
(208) 555-1793
Hire Date:
1976-12-15

Education

1972
Computer Engineering, Ph.D. University of Washington

1969
Music and Physics, M.A. Vassar College

Work History

2/83 - present
Architect, OCR Development Designing the architecture of OCR products.

12/76 - 1/83
Text Programmer Optical character recognition (OCR) programming in PL/I.

9/72 - 11/76
Punch Card Quality Analyst Checking punch cards met quality specifications.

Interests

Adamson Photo

Figure 15. Bruce Adamson

_ sqlx0adm pseg38pp

Adamson Resume

The following text is found in the db200150.asc and db200150.scr files.

Resume: Bruce Adamson

 

Personal Information

Address:
3600 Steeles Ave Mellonville, Idaho 83757
Phone:
(208) 555-4489
Birthdate:
May 17, 1947
Sex:
Male
Marital Status:
Married
Height:
6'0"
Weight:
175 lbs.

Department Information

Employee Number:
000150
Dept Number:
D11
Manager:
Irving Stern
Position:
Designer
Phone:
(208) 555-4510
Hire Date:
1972-02-12

Education

1971
Environmental Engineering, M.Sc. Johns Hopkins University

1968
American History, B.A. Northwestern University

Work History

8/79 - present
Neural Network Design Developing neural networks for machine intelligence products.

2/72 - 7/79
Robot Vision Development Developing rule-based systems to emulate sight.

9/71 - 1/72
Numerical Integration Specialist Helping bank systems communicate with each other.

Interests

Walker Photo

Figure 16. James H. Walker

_ sqlx0wak pseg38pp

Walker Resume

The following text is found in the db200190.asc and db200190.scr files.

Resume: James H. Walker

 

Personal Information

Address:
3500 Steeles Ave Mellonville, Idaho 83757
Phone:
(208) 555-7325
Birthdate:
June 25, 1952
Sex:
Male
Marital Status:
Single
Height:
5'11"
Weight:
166 lbs.

Department Information

Employee Number:
000190
Dept Number:
D11
Manager:
Irving Stern
Position:
Designer
Phone:
(208) 555-2986
Hire Date:
1974-07-26

Education

1974
Computer Studies, B.Sc. University of Massachusetts

1972
Linguistic Anthropology, B.A. University of Toronto

Work History

6/87 - present
Microcode Design Optimizing algorithms for mathematical functions.

4/77 - 5/87
Printer Technical Support Installing and supporting laser printers.

9/74 - 3/77
Maintenance Programming Patching assembly language compiler for mainframes.

Interests


[ Top of Page | Previous Page | Next Page ]