I have a form that has a five checkboxes. Two of the checkboxes (let's call them box4 and box5) cannot both be checked. For example, if box4 is checked, box5 will uncheck and vice versa. I am new to SQL/PL and do not know what to code in the trigger to get this done.
Why doesn't the Oracle optimizer use my index?
Querying too much data
Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table.
So, the obvious side…
Configuring and using Oracle Database Gateway for ODBC
First, a brief summary of what a Database Gateway is. A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…