Oracle Forms Interactive Workbook Book

	Introduction	xi
	Acknowledgments	xvii
	About the Author	xix
Chapter 1	Concepts and Objects	1
Lab 1.1	Oracle Forms Concepts	2
1.1.1	Explain How Oracle Forms Works	4
Lab 1.2	Mandatory Forms Objects	11
1.2.1	Identify Items and Their Types	17
1.2.2	Identify Canvases and Frames	18
1.2.3	Define Base-table Blocks	19
1.2.4	Understand Modules	20
1.2.5	Relate the Mandatory Forms Elements	20
	Chapter 1 Test Your Thinking	30
Chapter 2	Wizards and Files	31
Lab 2.1	The Data Block and Layout Wizards	32
2.1.1	Use the Data Block and Layout Wizards	42
2.1.2	Reentering the Wizards	43
Lab 2.2	Oracle Forms Files	53
2.2.1	Differentiate Between Source and Executable Files	54
2.2.2	Compile Binary Files into Executable Files	55
2.2.3	Run Executable Files	57
	Chapter 2 Test Your Thinking	63
Chapter 3	The Development Environment	65
Lab 3.1	The Object Navigator	66
3.1.1	Open and Identify Objects	68
3.1.2	Create and Delete objects	69
3.1.3	Drag & Drop and Cut & Paste Objects	70
3.1.4	Run and Save Forms	72
3.1.5	View Database Objects	72
Lab 3.2	The Property Palette	84
3.2.1	View Properties	86
3.2.2	Change Properties	86
Lab 3.3	The Layout Editor	93
3.3.1	Create and Format Objects	95
3.3.2	Arrange and Size Objects	97
	Chapter 3 Test Your Thinking	105
Chapter 4	Master-Detail Forms	107
Lab 4.1	Master-Detail Forms	108
4.1.1	Create a Master-Detail Form	110
4.1.2	Work with Master-Detail Forms and Relations	112
	Chapter 4 Test Your Thinking	124
Chapter 5	Items	125
Lab 5.1	Text Items and Display Items	126
5.1.1	Create and Define Text Items Without the Wizard	127
5.1.2	Create and Define Display Items	131
Lab 5.2	Buttons, List Items, Radio Groups, and Check Boxes	143
5.2.1	Create Buttons	147
5.2.2	Put Simple Code Behind Buttons	148
5.2.3	Create List Items	150
5.2.4	Create Radio Groups	153
5.2.5	Create Check Boxes	155
	Chapter 5 Test Your Thinking	169
Chapter 6	Triggers & Built-ins	171
Lab 6.1	Trigger Basics	172
6.1.1	Use PL/SQL and SQL in Triggers	175
6.1.2	Understand Trigger Scope	176
6.1.3	Categorize Triggers	178
Lab 6.2	Creating Triggers of Various Types	187
6.2.1	Create Query Triggers	189
6.2.2	Create Validation Triggers	192
6.2.3	Create Transactional Triggers	195
6.2.4	Create Key Triggers	197
Lab 6.3	Forms Built-ins	213
6.3.1	Use Forms Built-ins	216
	Chapter 6 Test Your Thinking	223
Chapter 7	LOVs and Alerts	225
Lab 7.1	Lists of Values (LOVs)	226
7.1.1	Create LOVs	228
7.1.2	Display LOVs	233
Lab 7.2	Alerts	248
7.2.1	Create and Display Alerts	251
	Chapter 7 Test Your Thinking	259
Chapter 8	Canvases and Windows	261
Lab 8.1	Canvas and Window Concepts	262
8.1.1	Understand Windows	267
8.1.2	Understand Canvases	269
Lab 8.2	Content Canvases and Windows	277
8.2.1	Create a Content Canvas and Window	278
Lab 8.3	Stacked Canvases	287
8.3.1	Create and Display Stacked Canvases	289
LAB 8.4	Toolbars	298
8.4.1	Create a Toolbar Canvas	299
8.4.2	Use the Toolbar in Another Form	302
	Chapter 8 Test Your Thinking	311
Chapter 9	Reusable Objects	313
Lab 9.1	Subclassing	314
9.1.1	Subclass Objects	315
Lab 9.2	Visual Attributes and Property Classes	323
9.2.1	Create and Apply Named Visual Attributes	325
9.2.2	Create and Apply Property Classes	327
Lab 9.3	Object Groups and Object Libraries	336
9.3.1	Create and Reuse Object Groups	338
9.3.2	Create and Utilize Object Libraries	341
Lab 9.4	Template Forms	348
9.4.1	Create and Use Template Forms	349
	Chapter 9 Test Your Thinking	352
Chapter 10	Reusable Code	353
Lab 10.1	Program Units	354
10.1.1	Create a Program Unit	357
Lab 10.2	PL/SQL Libraries	362
10.2.1	Create and Attach PL/SQL Libraries	364
10.2.2	Use Indirect References in Library Code	366
Lab 10.3	Stored PL/SQL Objects	374
10.3.1	Use Stored PL/SQL Objects	375
Chapter 10	Test Your Thinking	379
Chapter 11	Multiple-Form Applications	381
Lab 11.1	Calling One Form from Another	382
11.1.1	Open Multiple Forms	385
11.1.2	Create a Parameter List and Pass It to a Form	387
	Chapter 11 Test Your Thinking	400
Chapter 12	Oracle Forms and Oracle Reports	403
Lab 12.1	Running Oracle Reports from Forms	404
12.1.1	Run an Oracle Report with run_product	406
12.1.2	Run an Oracle Report with run_report_object	407
Lab 12.2	Passing Parameters to Reports	414
12.2.1	Pass Parameters to a Report	416
	Chapter 12 Test Your Thinking	420
Chapter 13	Forms Menus	421
Lab 13.1	Menu Modules	422
13.1.1	Create Menus and Menu Items	426
Lab 13.2	Menu Security	435
13.2.1	Implement Menu Security	436
	Chapter 13 Test Your Thinking	443
	Appendix A	445
	Appendix B	455
	Index	461