Answer Posted / din dayal singh
Integrity constraints are used to ensure accuracy and
consistency of data in a relational database.[citation
needed] Data integrity is handled in a relational database
through the concept of referential integrity. There are many
types of integrity constraints that play a role in
referential integrity.
Entity integrity
Referential Integrity
Domain Integrity
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you assign multiple query result rows to a variable?
What is a package in oracle?
Hi Can any one tell me what are the API's used in requisition import.
> 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?
Explain an exception?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What are the ansi data types supported in oracle?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
How to check the oracle tns settings?
How to use "startup" command to start default instance?
What is the difference between post-database commit and post-form commit?
What to do if the startbd.bat failed to start the xe instance?
How to invoke the original export import utilities?
How to retrieve values from data fields in record variables?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
