Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 558

A declarative mechanism such as a check or foreign key that enforces some data integrity rule in a database.

14
votes
Oracle: Since Oracle doesn't index entries where all indexed columns are null, you can use a function-based unique index: create table foo(bar integer, chk char(1) not null check (chk in('Y', 'N') …
answered Aug 19 '11 by Vincent Malgrat
6
votes
If CASE_RECOMMENDATION.CASE_STAGE_ID is unique, you can use referential integrity with a virtual column (11g+) to make it conditional: alter table CASE_RECOMMENDATION ADD CONSTRAINT … virtual column is defined when stage_id=1646 alter table case_stage add constraint chk_1646 check ( stage_id!=1646 or previous_case_stage_id is not null); -- referential integrity alter table …
answered Sep 13 '12 by Vincent Malgrat