Example of shorthand for a row constraint - sql, PL-SQL Programming

Example of Shorthand for a row constraint

Example: Shorthand for a row constraint

ALTER TABLE EXAM_MARK

ADD CONSTRAINT Mark_in_range

CHECK (Mark BETWEEN 0 AND 100);

Actually, it's not quite the only way. The constraint can be included in the column definition for Mark in the CREATE TABLE statement for EXAM_MARK, as shown in Example. A constraint declared as part of a column definition is called a column constraint.

Posted Date: 1/18/2013 7:49:28 AM | Location : United States







Related Discussions:- Example of shorthand for a row constraint - sql, Assignment Help, Ask Question on Example of shorthand for a row constraint - sql, Get Answer, Expert's Help, Example of shorthand for a row constraint - sql Discussions

Write discussion on Example of shorthand for a row constraint - sql
Your posts are moderated
Related Questions
FOR-LOOP While the number of iterations through a WHILE loop is unknown till the loop completes, then the number of iterations through a FOR loop is known before the loop is ent

Cursor FOR Loops In most cases that need an explicit cursor, you can simplify the coding by using a cursor FOR loop rather of the OPEN, FETCH, and CLOSE statements. A cursor FO

Naming Conventions The similar naming conventions apply to all PL/SQL program items and units including the variables, cursors, constants, cursor variables, procedures, exception

Declaring Cursor Variables Once a REF CURSOR type is define by you, and then you can declare the cursor variables of that type in any PL/SQL block or subprogram. In the exampl

Effects of NULL in Table Literal When a VALUES expression appears as the source value for an SQL INSERT statement, the key word NULL can appear as a field value, such that for

Literals A literal is an explicit numeric, string, character, or Boolean value not represented by an identifier. Numeric literal 147 and the Boolean literal FALSE are some of

Using DEFAULT You can use the keyword DEFAULT rather than that of the assignment operator to initialize the variables. For e.g. the declaration blood_type CHAR := ’O’; it can b

Nested Tables versus Index-by Tables The Index-by tables and nested tables are just similar. For e.g.  They have similar structure and their individual elements are accessed in

Example of GROUPBY Operator Example: How many students sat each exam, using GROUP BY, NATURAL LEFT JOIN, and COALESCE SELECT CourseId, COALESCE (n, 0) AS n FROM COURS

BETWEEN and NOT BETWEEN Operator in SQL Example: Restricting exam marks to between 0 and 100 CREATE ASSERTION Marks_between_0_and_100 CHECK (NOT EXISTS (SELECT * FROM