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

Answer / prna

SELECT MIN(SAL) FROM (SELECT SAL FROM (select sal from emp group by sal order by sal desc) WHERE ROWNUM<=3)

How a tablespace is related to data files?

0 Answers  

---

After update how do u know how many records got updated

4 Answers   TCS,

---

HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?

3 Answers  

---

How can we find out the duplicate values in an oracle table?

0 Answers  

---

How to name query output columns in oracle?

0 Answers  

---

select trunc(round(156.00,-1),-1) from dual;

2 Answers  

---

What is meant by joins?

0 Answers  

---

Explain the difference between sql and oracle?

0 Answers  

---

What happens if the update subquery returns multiple rows?

0 Answers  

---

If server is in US and client is in india there is timezone is diffrence, How can we display date in indian time when data is displayed from US server timezone?

1 Answers  

---

how to do daily transactions with out sql* loader control file regesterd in apps?

0 Answers   Arrow Electronics,

---

what is the output of select * from emp where null=null & select * from emp where 1=1

8 Answers   IMS Health, NIIT,

---