Rem This is the sql creation script for the Pro*C lobdemo1
Rem Note that a separate demo exists which features the use of OCI calls
Rem in a Pro*C program
/
connect scott/tiger
/
Rem Make sure database has no license_table floating around
/
drop table license_table
/
Rem ABSTRACTION:
Rem A license table reduces the notion of a driver's license into four 
Rem distinct components - a unique social security number (sss), 
Rem a name (name), a picture (mug_shot) and a text summary of misc. info
Rem including the person's address and phone number.
/
Rem IMPLEMENTATION:
Rem Our implementation follows this abstraction
/
create table license_table(
  sss char(9),
  name varchar2(50),
  txt_summary clob)
/
insert into license_table 
	values('971517006', 'Dennis Kernighan', 
	'Wearing a Bright Orange Shirt - 31 Oct 1996')
/
insert into license_table 
	values('555001212', 'Eight H. Number', 
	'Driving Under the Influence - 1 Jan 1997')
/
insert into license_table 
 	values('010101010', 'P. Doughboy', 
	'Impersonating An Oracle Employee - 10 Jan 1997')
/
insert into license_table
 	values('555377012', 'Calvin N. Hobbes', 
	'Driving Under the Influence - 30 Nov 1996')
/
select count(*) from license_table
/
Rem Commit to save
commit
/
