Explain enable novalidate constraint.
- 1 Answers
- 1168 Views
- I also Faced
- E-Mail Answers
Answer / Rishabh Kanthariya
The ENABLE NOVALIDATE constraint in Oracle allows you to disable validation checks for a specific CHECK constraint. By using the ENABLE NOVALIDATE clause, you can bypass the validation check for a constraint without dropping or altering it. However, this should be used with caution because disabling validation can lead to inserting or updating data that violates the intended constraints, which might result in inconsistent or corrupt data within your database.
| Is This Answer Correct ? | 0 Yes | 0 No |
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
Define Transaction ?
What is the data type of dual table?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
When do you get a .pll extension in oracle? Explain its importance
why can't we assign not null constraint as table level constraint
How do I find my oracle client driver version?
Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table
What is oracle rownum?
what are the advantages of running a database in archive log mode?
IS it possible to built the oracle database without setting the kernal parameters?
How to get last row id?
Oracle General 
