The biggest limitation of the CHECK constraint is as follows:- The condition needs to be a boolean expression that is being evaluated using the values in the row being inserted or updated. It can also not contain any subqueries whatsoever.
State the limitations of the CHECK constraint.
Share:
You May Also Like
Oracle has several modes for shutting down the database: In normal mode, the database is shut down by default. It...
- Interview
- November 30, 2023
Materialized views are items that contain condensed sets of data from base tables that have been summarized, clustered, or aggregated. They...
- Interview
- November 30, 2023
Every database in Oracle has a tablespace called SYSTEM, which is generated automatically when the database is created. It also...
- Interview
- November 30, 2023
