|
|
|
Re: Constraint problem for flag [message #642137 is a reply to message #642135] |
Thu, 03 September 2015 09:01 |
|
brown_zzz
Messages: 39 Registered: August 2012 Location: United Kingdom
|
Member |
|
|
Sorry!
drop table cars;
CREATE TABLE cars
(
ID NUMBER(28,0) NOT NULL ENABLE,
car VARCHAR2(10) NOT NULL,
value NUMBER(28,0) NOT NULL ENABLE,
cr_date DATE NOT NULL ENABLE,
is_curr_flag VARCHAR2(1),
CONSTRAINT PK_CARS PRIMARY KEY (ID)
) ;
INSERT INTO CARS VALUES( 01, 'Ford', 95000, '05-Mar-15', 'Y' );
INSERT INTO CARS VALUES( 02, 'Ford', 10000, '05-Mar-15', NULL );
INSERT INTO CARS VALUES( 03, 'Ford', 11000, '05-Jan-15', NULL );
INSERT INTO CARS VALUES( 04, 'Audi', 15000, '01-Jan-15', 'Y' );
INSERT INTO CARS VALUES( 05, 'Audi', 18000, '03-Aug-14', NULL );
INSERT INTO CARS VALUES( 06, 'Audi', 20000, '05-Sep-14', NULL );
INSERT INTO CARS VALUES( 07, 'Audi', 22000, '01-Sep-14', NULL );
|
|
|
|
|