How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?

2 Answers   Infosys,

---

How do I know if oracle is installed on windows?

0 Answers  

---

Is there a combination of "like" and "in" in sql?

0 Answers  

---

I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?

2 Answers   Zensar,

---

Where do we use decode and case statements?

0 Answers  

---

Why required to run root.sh at the time of installation and what exactly it will do

1 Answers  

---

What are operators in oracle?

0 Answers  

---

Explain the types of exception?

0 Answers  

---

Explain the features of oracle?

0 Answers  

---

In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?

4 Answers   Cap Gemini,

---

what is analyze command ? what kind of statistics does it generate?

2 Answers  

---

how can we store any pdf file in oracle

0 Answers  

---