Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7945 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / krupananda
It is not possible to add not null constraint on existing
column which contains null values.
but we can add not null constraint from 101 record onwards
using triggers.
using triggers it is possible to restrict not null values
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is oracle host variable?
What is the difference between 10g OEM and 11g OEM?
How to delete a column in an existing table?
How to save query output to a local file?
What is the usage of synonyms?
What are the differences between lov and list item?
What are the execution control statements?
What are set operators?
When do you get a .pll extension in oracle? Explain its importance
Why do we need oracle client?
How to add a new column to an existing table in oracle?
How to use existing values in update statements using oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
Write a trigger example in oracle?
What are the roles of dba?
