My Oracle Support Banner

Performing Last Criteria Programmatically in Forms (Doc ID 45052.1)

Last updated on DECEMBER 08, 2023

Applies to:

Oracle Forms - Version 6.0.8 and later
Oracle Forms for OCI - Version and later
Information in this document applies to any platform.


The default Oracle Forms runtime menu provides the Last criteria option from the Query pull-down, which brings up the most recent query
criteria. You can implement this same functionality, so you can avoid altering the default WHERE clause of a block. This bulletin describes
how to do this and simulates the exact functionality of the Last criteria menu option.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.