How do forms relate to individual database tables in ORACLE?
Behind each block on a form is the database table from which ORACLE draws the information which appears in that block. When a form is displayed, it presents fields which correspond to columns on the database tables, and text such as field names, form titles, etc. Forms act as a structured “guide” to information held in the database. Using a form, users can quickly insert, change, delete or save information to the database tables. Users can also use forms to query information from the database, using the fields to enter search criteria, rather than phrase the query in SQL terminology. Behind each field on a form, a developer has written a SQL statement which extracts the information from the database table and presents it to the user.
