Example of Check Constraints

Example: Workaround for when subqueries not permitted in CHECK constraints

CREATE FUNCTION NO_MORE_THAN_20000_ENROLMENTS ( )

RETURNS BOOLEAN;

RETURN (SELECT COUNT (*) FROM IS_ENROLLED_ON) <= 20000;

ALTER TABLE IS_ENROLLED_ON

ADD CONSTRAINT MAX_ENROLMENTS

CHECK (NO_MORE_THAN_20000_ENROLMENTS ( ));

Posted Date: 1/18/2013 7:17:46 AM | Location : United States

Ask an Expert

Related Discussions:- Example of check constraints - sql, Assignment Help, Ask Question on Example of check constraints - sql, Get Answer, Expert's Help, Example of check constraints - sql Discussions

Write discussion on Example of check constraints - sql
Your posts are moderated

Write your message here..

Related Questions

Multiple assignment - sql, Multiple Assignment- SQL SQL supports mult... Multiple Assignment- SQL SQL supports multiple assignment to local variables and also applies multiple assignment semantics in SET clauses of UPDATE statements, but does not

Anatomy of a command, Anatomy of a Command Figure, showing a simple S... Anatomy of a Command Figure, showing a simple SQL command, is almost identical to its counterpart in the theory book. The only difference arises from the fact that SQL uses a

Components of an object type in pl/sql, Components of an Object Type: A... Components of an Object Type: An object type encapsulates the operations and data. Therefore, you can declare the methods and attributes in an object type specification, but no

Delete statement - syntax, DELETE Statement The DELETE statement elimin... DELETE Statement The DELETE statement eliminates whole rows of data from the specified table or view. Syntax:

Collection methods in pl sql, Collection Methods:   The collection me... Collection Methods:   The collection method is a built-in function or procedure which operates on the collections and is called using the dot notation. The methods like the C

Sql, Write a cursor to open an employee database and fetch the employee rec... Write a cursor to open an employee database and fetch the employee record whose age is greater than 45

Using exception_init - user-defined exceptions, Using EXCEPTION_INIT T... Using EXCEPTION_INIT To handle unnamed internal exceptions, you should use the OTHERS handler or the pragma EXCEPTION_INIT. The pragma is a compiler directive that can be th

Data abstraction, Data Abstraction The Data abstraction extracts the im... Data Abstraction The Data abstraction extracts the important properties of data while ignoring the not necessary details. Once you design a data structure, you can fail to reme

Declaring a cursor, Declaring a Cursor The Forward references are not ... Declaring a Cursor The Forward references are not allowed in the PL/SQL. Therefore, you must declare a cursor before referencing it in other statements. Whenever you declare a

Enrolment was split - sql, Enrolment was split - SQL Example shows ho... Enrolment was split - SQL Example shows how relvars IS_CALLED and IS_ENROLLED_ON can be derived from the original ENROLMENT relvar, using projection in the initial assignment