what is integrity constrains?
Answers were Sorted based on User's Feedback
Answer / srikanth
integrity constraints meanans Data integrity allows to
define certain data quality requirements that the data in
the database needs to meet. If a user tries to insert data
that doesn't meet these requirements, Oracle will not allow.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nirav21686
Integrity constraints are used to ensure accuracy and
consistency of data in a relational database
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kumara swamy naidu
it is a state in which all the data values stored in the database are correct.enforcing this we can make the quality of the data in the data base
| Is This Answer Correct ? | 0 Yes | 0 No |
How to drop a stored procedure in oracle?
Can objects of the same Schema reside in different tablespaces.?
How to use existing values in update statements using oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What is program global area (pga) in oracle?
How to rename an existing table?
What is a data lock in oracle?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
what are corelated subqueries
what is RAID technology?which is better RAID 0+1 OR RAID 5?
what is foreign key?
How to get a list of all background sessions in the database?