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,

---

How to retrieve first and last records from a table?

7 Answers   DELL, QSmart,

---

what is the difference between rollback & commit? can a foreign key has null value?

6 Answers  

---

How to rename an index?

0 Answers  

---

hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4

1 Answers   CTS,

---

i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?

2 Answers   Microsoft,

---

What is data block in Oracle?

0 Answers   MCN Solutions,

---

How to count groups returned with the group by clause in oracle?

0 Answers  

---

What is connection pooling in oracle?

0 Answers  

---

can u call user defined functions in select statements

2 Answers  

---

1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?

2 Answers   Accenture,

---

how to find out largest value in a table

2 Answers  

---