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
LIKE Operator You use the LIKE operator to compare the character value to a pattern. The Case is significant. LIKE returns the Boolean value TRUE when the character patterns mat

Datatype Conversion At times it is necessary to convert a value from one datatype to another. For e.g. if you want to inspect a rowid, you should convert it to a character stri

What Are Subprograms? The Subprograms are named PL/SQL blocks which can take parameters and be invoked. The PL/SQL has 2 types of subprograms known as the procedure s and func

Keyword & Parameter Description: WHEN: This keyword introduces the exception handler. You can have many exceptions execute the similar sequence of the statements by follo

BETWEEN Operator The operator BETWEEN, tests whether the value lies in a specified series. That means "greater than or equivalent to low value and less than or equivalent to hig

The requirements as follows: Create a folder called "SECURITY" on the server and upload all your project files to that folder. Please note, the "SECURITY" folder is NOT to be IN

Project Description: We organize an online system called ACPAS we have created a project called EVO that can be use by our customers to integrate their web sites with the Acpas

LAWS / RULES - Dollo's Law                     :           Living organisms do exhibit evolutionary irreversibility or evolution is irreversible. Williston's Law

Question: a) Given the following relation: Location(loc_id, bldg_code, room, capacity) The underlined field is a primary key. (i) Write a PL/SQL program using the impl

Sequential Control Dissimilar to the IF and LOOP statements, the GOTO and NULL statements are not important to the PL/SQL programming. The configuration of PL/SQL is such that th