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
Write a stored procedure that accepts the post code in which the customer resides as the input parameter. The procedure should then use an explicit cursor to display comprehensive

Oracle 11 G new features associated with this release:- Enhanced ILM  - Information Lifecycle Management (ILM) has been around for the almost 10 years, but Oracle has made

Data Types in SQL - Decimal DECIMAL, NUMERIC, REAL, FLOAT and various other terms for various sets of rational numbers. When these key words are specified for the declared typ

IN Operator The operator IN tests the set membership. This means "equal to any member of." The set may have nulls, but they are ignored. For illustration, the statement below do

Package Body: The package specification is implemented by the package body. That is, the package body has the definition of every cursor and the subprogram declared in the pac

SSRS Report Writing Project Description: This report is part of a larger project to make a SQL Server Reporting Service (SSRS) based reporting solution. There can be more rep

Grouping and Ungrouping in SQL Example specifying EXAM_MARK in place of COURSE in the main FROM clause. Example: Obtaining C_ER2 from EXAM_MARK SELECT CourseId, CAST

Using the BULK COLLECT Clause The keywords BULK COLLECT specify the SQL engine to bulk-bind output collections before returning them to the PL/SQL engine. You can use these ke

RETURN Statement The RETURN statement instantly completes the execution of a subprogram and returns control to the caller. The Execution then resumes with the statement below t

Using FOR UPDATE If you declare a cursor which will be referenced in the CURRENT OF clause of an UPDATE or DELETE statement, you should use the FOR UPDATE clause to obtain an