SQL Erste Schritte

Beispieldateien mit Datentypen BLOB und CLOB

In diesem Abschnitt werden die Daten dargestellt, die sich in den Dateien EMP_PHOTO (Fotos der Mitarbeiter) und EMP_RESUME (Lebensläufe der Mitarbeiter) befinden.

Quintana - Foto

Abbildung 7. Delores M. Quintana

_ sqlx0qin pseg38pp

Quintana - Lebenslauf

Der folgende Text befindet sich in den Dateien db200130.asc und 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 - Foto

Abbildung 8. Heather A. Nicholls

_ sqlx0nic pseg38pp

Nicholls - Lebenslauf

Der folgende Text befindet sich in den Dateien db200140.asc und 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 - Foto

Abbildung 9. Bruce Adamson

_ sqlx0adm pseg38pp

Adamson - Lebenslauf

Der folgende Text befindet sich in den Dateien db200150.asc und 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 - Foto

Abbildung 10. James H. Walker

_ sqlx0wak pseg38pp

Walker - Lebenslauf

Der folgende Text befindet sich in den Dateien db200190.asc und 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


[ Seitenanfang | Vorherige Seite | Nächste Seite | Inhaltsverzeichnis | Index ]