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
Left and Right Joins LEFT OUTER JOIN can be used when you want to retrieve the data from the main table (table1) even if there is no match in other tables (table_2, table_3...

Project Description: I want to write some SQL statements. The things I need are between pages 5-7. The only problem is that i want it till tomorrow. Skills required is SQL

Using raise_application_error The Package DBMS_STANDARD that is supplied with Oracle gives language facilities that help your application to interact with Oracle. For illustra

Use Native Dynamic SQL A few programs (a normal-purpose report writer for illustration) should build and process a variety of SQL statements at run time. Therefore, their full

%TYPE: This attribute gives the datatype of a formerly declared collection, cursor variable, object, field, record, database column, or variable. Datatype: This is simply

Example of GROUP BY and COLLECT Operator Example: Using GROUP BY and COLLECT to obtain C_ER2 SELECT CourseId, CAST ( COLLECT (ROW (StudentId, Mark)) AS ROW (Studen

SQL Operators The PL/SQL uses all the SQL set, comparison, and row operators in the SQL statements. This part briefly describes some of these operators.  1. Comparison Opera

Special cases of projection This section describes the identity projection, r {ALL BUT}, and the projection on no attributes, r { }, which yields TABLE_DUM when r is empty, ot

Important Distinctions The list of important distinctions are given below: Value versus variable Syntax versus semantics Variable versus variable reference

Cursor Variables As Parameters You can declare the cursor variables as the formal parameters of the functions and procedures. In the illustration below, you define the REF CUR