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
Using SET TRANSACTION You use the SET TRANSACTION statement to begin the read-only or read-write transaction, start an isolation level, or assign your present transaction to a

Declaring Subprograms   You can declare subprograms in any PL/SQL subprogram, block, or package. But, you should declare subprograms at the end of the declarative part after a

Using PRIOR and NEXT The PRIOR(n) returns the index number that precede index n in a collection. The NEXT(n) returns the index number which succeed the index n. If n has no pr

Using FORALL and BULK COLLECT Together You can unite the BULK COLLECT clause with the FORALL statement, in that case, the SQL engine bulk-binds column values incrementally. In

Project Description: I want somebody who can help me with an idea that I have been working on for a few months now. The person will require extensive knowledge of warcraft 3 PvP

Cursors The Oracle uses work areas to execute the SQL statements and to store process information. A PL/SQL construct known as the cursor. Let's you assume name a work area and

Name Resolution In potentially uncertain SQL statements, the names of the database columns take precedence over the names of the local variables and formal parameters. For e.g.

V ariables and Constants in PL/SQL The PL/SQL permits you to declare constants and variables, and then use them in SQL and procedural statements anywhere in the expression. Th

Ensuring Backward Compatibility   The PL/SQL Version 2 permits some abnormal behavior which Version 8 disallows. Particularly, Version 2 permits you to (i) Make the forw

Updating Objects: To change the attributes of objects in an object table, you can use the UPDATE statement, as the illustration below shows: BEGIN UPDATE persons p SET p