I am creating a new application based on oracle forms6.In the same form, I give the users all the 4 options(Create/Modify/Delete/View).During viewing, I use execute_query and get the record, and disable all the fields in the form.

This is locking all the records and does not allow others to modify this data.

My Question is how does the Execute_query work. Will it lock the records,so that others cannot modify these records.