How to create a check constraint between two columns in SQL?

oracle check-constraints
Unknown picture Unknown · Feb 25, 2009 · Viewed 8.9k times · Source

I am trying to create a Basic pay (BP) table with

CREATE TABLE bp (
   bpid       VARCHAR(5), 
      FOREIGN KEY (bpid) REFERENCES designation(desigid), 
   upperlimit DECIMAL(10,2) NOT NULL, 
   lowerlimit DECIMAL(10,2) NOT NULL, 
   increment  DECIMAL(10,2) NOT NULL 
      CONSTRAINT llvalid CHECK (upperlimit > lowerlimit)
 );

As you can see near the ending, I want to check if upperlimit is greater than lowerlimit, how can I do that?

Answer

Jens Schauder picture Jens Schauder · Feb 25, 2009

It might (probably does) depend on the data base you use.

Comparing to the oracle syntax (e.g. here: http://www.techonthenet.com/oracle/check.php), what you are missing might be a ',' between NULL and CONSTRAINT

Related questions

CHECK CONSTRAINT in Oracle SQL

I have the following table Goods_In_Wagon(Goods_ID,Wagon_ID,Total_Weight). I need to create a number of if statement check constraint that says "IF WAGON_ID is between 90 and 99 THEN Total_Weight must be greater than 10." …

Read More
Oracle 11g - Check constraint with RegEx

I'm using Oracle 11g, and trying to create a table define constraints on the creation. I was trying to add check constraint to validate some information (like e-mail address, phone number, etc...) Is there something in Oracle 11g that would …

Read More
Oracle: how to formulate a complex constraint with case when

The following conditional constraint simply doesn't work. Is it possible to formulate in a working way? ALTER TABLE eni_trasc_voci_pwr_fatt ADD CONSTRAINT tvp_constraint_1 CHECK ( CASE WHEN TVP_CODICE_ASSOGGETAMEN = '-' THEN tvp_regione IS NULL END);

Read More