Block is logical owner of items. It
provides a mechanism for grouping related items into a functional unit for
storing, displaying and manipulating records.
Types of Blocks
- Data Blocks:-
Data blocks are associated with data
(table columns) within a database.
By default, the association between a
data block and the database allows operators to automatically query, update,
insert, and delete rows within a database.
Data blocks can be based on database
tables, views, procedures, or transactional triggers.
- Control Blocks:-
A control block is not associated with the database, and the
items in a control block do not relate to table columns within a database.
All blocks are either single-record or multi-record blocks:
A single-record block displays one record at a time.
A multi-record block displays more than one record at a
time.
In addition, a data block can also be a master or detail
block:
Master block displays a master record associated with detail
records displayed in a detail block.
A detail block displays detail records
associated with a master record displayed in master block.
No comments:
Post a Comment