SQL 概説

BLOB および CLOB データ・タイプのサンプル・ファイル

ここに示すのは、 EMP_PHOTO ファイル (従業員の写真) と EMP_RESUME ファイル (従業員の履歴書) に含まれているデータです。

Quintana の写真

図 7. Delores M. Quintana

_ sqlx0qin pseg38pp

Quintana の履歴書

db200130.asc および db200130.scr のファイルに含まれているテキストは、 次のとおりです。

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 の写真

図 8. Heather A. Nicholls

_ sqlx0nic pseg38pp

Nicholls の履歴書

db200140.asc および db200140.scr のファイルに含まれているテキストは、 次のとおりです。

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 の写真

図 9. Bruce Adamson

_ sqlx0adm pseg38pp

Adamson の履歴書

db200150.asc および db200150.scr のファイルに含まれているテキストは、 次のとおりです。

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 の写真

図 10. James H. Walker

_ sqlx0wak pseg38pp

Walker の履歴書

db200190.asc および db200190.scr のファイルに含まれているテキストは、 次のとおりです。

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


[ ページのトップ | 前ページ | 次ページ | 目次 | 索引 ]