Yhyjyk

Is there any way to tell whether the shot is going to hit you or not?

Protecting Dualbooting Windows from dangerous code (like rm -rf)

Is flight data recorder erased after every flight?

What are the motivations for publishing new editions of an existing textbook, beyond new discoveries in a field?

Loose spokes after only a few rides

Return to UK after being refused entry years previously

If I score a critical hit on an 18 or higher, what are my chances of getting a critical hit if I roll 3d20?

Is a "Democratic" Feudal System Possible?

Would the motor reverse if phases swapped for this case?

Why is the maximum length of OpenWrt’s root password 8 characters?

What does ひと匙 mean in this manga and has it been used colloquially?

Why was M87 targetted for the Event Horizon Telescope instead of Sagittarius A*?

Are there incongruent pythagorean triangles with the same perimeter and same area?

What is the motivation for a law requiring 2 parties to consent for recording a conversation

Did Section 31 appear in Star Trek: The Next Generation?

How can I autofill dates in Excel excluding Sunday?

How to support a colleague who finds meetings extremely tiring?

"as much details as you can remember"

Landlord wants to switch my lease to a "Land contract" to "get back at the city"

Why didn't the Event Horizon Telescope team mention Sagittarius A*?

Multiply Two Integer Polynomials

Does the shape of a die affect the probability of a number being rolled?

How to notate time signature switching consistently every measure

Am I thawing this London Broil safely?

Building a conditional check constraint

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

2

I'm trying to build a conditional check constraint for my table TBL_AFIL, which has two fields:

• Fec_Renun DATE


• flg_afil INTEGER

Constraint: IF flg_afil=1 THEN Fec_Renun can not be NULL.

ALTER TABLE TBL_AFIL
ADD CONSTRAINT FecRenun_Not_Null CHECK (Fec_Renun IS not NULL and flg_afil =1) ;

But it throws this error:

ORA-02293: cannot validate (FecRenun_Not_Null) - check constraint violated

But when I run this query, it returns 0 rows.

SELECT * FROM TBL_AFIL
WHERE FEC_RENUN IS NULL
AND FLG_AFIL =1;

I know that to this constraint I could add ENABLE NOVALIDATE, but I'm intrigued why can't build this constraint.

oracle check-constraints

share|improve this question

asked 6 hours ago

DelmonteDelmonte

3894819

add a comment | 

2

I'm trying to build a conditional check constraint for my table TBL_AFIL, which has two fields:

• Fec_Renun DATE


• flg_afil INTEGER

Constraint: IF flg_afil=1 THEN Fec_Renun can not be NULL.

ALTER TABLE TBL_AFIL
ADD CONSTRAINT FecRenun_Not_Null CHECK (Fec_Renun IS not NULL and flg_afil =1) ;

But it throws this error:

ORA-02293: cannot validate (FecRenun_Not_Null) - check constraint violated

But when I run this query, it returns 0 rows.

SELECT * FROM TBL_AFIL
WHERE FEC_RENUN IS NULL
AND FLG_AFIL =1;

I know that to this constraint I could add ENABLE NOVALIDATE, but I'm intrigued why can't build this constraint.

oracle check-constraints

share|improve this question

asked 6 hours ago

DelmonteDelmonte

3894819

add a comment | 

I'm trying to build a conditional check constraint for my table TBL_AFIL, which has two fields:

• Fec_Renun DATE


• flg_afil INTEGER

Constraint: IF flg_afil=1 THEN Fec_Renun can not be NULL.

ALTER TABLE TBL_AFIL
ADD CONSTRAINT FecRenun_Not_Null CHECK (Fec_Renun IS not NULL and flg_afil =1) ;

But it throws this error:

ORA-02293: cannot validate (FecRenun_Not_Null) - check constraint violated

But when I run this query, it returns 0 rows.

SELECT * FROM TBL_AFIL
WHERE FEC_RENUN IS NULL
AND FLG_AFIL =1;

I know that to this constraint I could add ENABLE NOVALIDATE, but I'm intrigued why can't build this constraint.

oracle check-constraints

share|improve this question

asked 6 hours ago

DelmonteDelmonte

3894819

ALTER TABLE TBL_AFIL
ADD CONSTRAINT FecRenun_Not_Null CHECK (Fec_Renun IS not NULL and flg_afil =1) ;

ORA-02293: cannot validate (FecRenun_Not_Null) - check constraint violated

SELECT * FROM TBL_AFIL
WHERE FEC_RENUN IS NULL
AND FLG_AFIL =1;

share|improve this question

asked 6 hours ago

DelmonteDelmonte

3894819

share|improve this question

asked 6 hours ago

DelmonteDelmonte

3894819

asked 6 hours ago

DelmonteDelmonte

3894819

asked 6 hours ago

DelmonteDelmonte

3894819

1 Answer
1

active

oldest

votes

6

CHECK (NOT (flag_afil = 1 AND fec_renum IS NULL)) 

share|improve this answer

answered 5 hours ago

ypercubeᵀᴹypercubeᵀᴹ

78.4k11137221

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Awesome. Thanks.
  
  – Delmonte
  4 hours ago
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "182"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f234472%2fbuilding-a-conditional-check-constraint%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

6

CHECK (NOT (flag_afil = 1 AND fec_renum IS NULL)) 

share|improve this answer

answered 5 hours ago

ypercubeᵀᴹypercubeᵀᴹ

78.4k11137221

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Awesome. Thanks.
  
  – Delmonte
  4 hours ago
  

  
  
  
  

add a comment | 

6

CHECK (NOT (flag_afil = 1 AND fec_renum IS NULL)) 

share|improve this answer

answered 5 hours ago

ypercubeᵀᴹypercubeᵀᴹ

78.4k11137221

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Awesome. Thanks.
  
  – Delmonte
  4 hours ago
  

  
  
  
  

add a comment | 

CHECK (NOT (flag_afil = 1 AND fec_renum IS NULL)) 

share|improve this answer

answered 5 hours ago

ypercubeᵀᴹypercubeᵀᴹ

78.4k11137221

CHECK (NOT (flag_afil = 1 AND fec_renum IS NULL)) 

share|improve this answer

answered 5 hours ago

ypercubeᵀᴹypercubeᵀᴹ

78.4k11137221

answered 5 hours ago

ypercubeᵀᴹypercubeᵀᴹ

78.4k11137221

answered 5 hours ago

ypercubeᵀᴹypercubeᵀᴹ

78.4k11137221