Answer / allin

The Primarykey Constraint= unique + Not Null constraints.
For the Unique the meaning it self it is telling unique
value. won't accept duplicate values.

Thanks & Regards,
RatnaRao
9833847339

Answer / naren

When ever you create a primary key constraint on perticular
column in a table it creates clustered index by default,
it cannot allow null values and a table having only one
primary key constraint. But in the case of Unique Key
constraint, it allow only one null value, it creates non-
clustered index by default and a table having multiple
unique key constraints.


Regards
Naren Krishna

Answer / kiran

if unique then it can have null

but if column has primary then it cannot have null values
and duplicate values

19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.

2 Answers   Wipro,

---

what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .

5 Answers   HCL, LN,

---

cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..

2 Answers  

---

How to commit the current transaction in oracle?

0 Answers  

---

What are named parameters?

0 Answers  

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

0 Answers   Sierra Atlantica,

---

What is meant by recursive hints ?

1 Answers  

---

Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this

3 Answers   HCL,

---

how will I find the first 5 highest salaried employees in each dept in oracle.

22 Answers   IBM,

---

I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?

2 Answers   Philips,

---

Describe an oracle table?

0 Answers  

---

How to connect to oracle using service name instead of sid?

0 Answers  

---