Interested to Buy Any Domain ? << Click Here >> for more details...
Describe the different type of Integrity Constraints
supported by ORACLE ?
- 2 Answers
- 8066 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / allin
5 Different integrity constraints are given
1- Primarykey- creating the index and better performance
2- Unique - should not accept the repeated value
3- NotNull - Should enter any value
4- ForeignKey - can accept values which the values should
existed in primarykey column.Should accept
null values.
5- Check - between the two boundaries.
Thanks & Regards,
RatnaRao
9833847339
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / prna
SELECT MIN(SAL) FROM (SELECT SAL FROM (select sal from emp group by sal order by sal desc) WHERE ROWNUM<=3)
| Is This Answer Correct ? | 1 Yes | 1 No |
How to delete multiple rows from a table in oracle?
What is oracle join syntax?
Does oracle charge for java?
how will I find the first 5 highest salaried employees in each dept in oracle.
after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble
What are the differences between char and varchar2 in oracle?
How to set up autotrace for a user account?
IS it possible to built the oracle database without setting the kernal parameters?
How to use "in" parameter properly?
How to define default values for formal parameters?
find out first highest salary?
10 Answers Verinon Technology Solutions,
how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?
Oracle General 
