Between and not between operator in sql, PL-SQL Programming

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 EXAM_MARK

WHERE Mark NOT BETWEEN 0 AND 100));

Posted Date: 1/18/2013 7:45:47 AM | Location : United States







Related Discussions:- Between and not between operator in sql, Assignment Help, Ask Question on Between and not between operator in sql, Get Answer, Expert's Help, Between and not between operator in sql Discussions

Write discussion on Between and not between operator in sql
Your posts are moderated
Related Questions
Expressions   An expression is a randomly complex combination of the constants, variables, literals, operators, & function calls. The simplest expression is the single variabl

what is the use of declare keyword

ROWNUM The ROWNUM returns a number representing the order in which a row was selected from the table. The first row selected has a ROWNUM of 1; the second row has a ROWNUM of

Updating Variables For assignment, SQL uses the key word SET, as in SET X = X + 1 (read as "set X equal to X+1") rather than X: = X + 1 as found in many computer languages.

SELECT INTO Statement   The SELECT INTO statement retrieve data from one or more database tables, and then assigns the selected values to the variables or fields. Syntax:

%TYPE Attribute The %TYPE attribute gives the datatype of a record, field, nested table, database column, or the variable. You can use the %TYPE attribute as the datatype speci

Understanding Nested Tables Within the database, the nested tables can be considered as one-column database tables. The Oracle stores the rows of a nested table in no specific o

Explicit Cursors The set of rows returned by the query can include zero, one, or multiple rows, depending on how many rows meet your search criteria. Whenever a query returns

JOIN and AND in SQL In this Section is all about one operator, JOIN. SQL's closest counterpart, NATURAL JOIN, has already been covered. Here we look at several other "join" op

Opening a Cursor Variable The OPEN-FOR statement relates a cursor variable with the multi-row query, executes the query, and then identifies the result set. The syntax for ope