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,

---

Explain the family trees and connection by clause

0 Answers  

---

What is java oracle used for?

0 Answers  

---

Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).

1 Answers  

---

What are the parameters that we can pass through a stored procedure?

0 Answers  

---

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

0 Answers  

---

How to define a data source name (dsn) in odbc manager?

0 Answers  

---

I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.

5 Answers   Microsoft, Oracle, TCS,

---

Give syntax for SQL and ORACLE joins.

0 Answers   TCS,

---

How to insert a new row into a table in oracle?

0 Answers  

---

What is a user role in oracle?

0 Answers  

---

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,

---