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?
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
How to start your 10g xe server from command line?
How to connect to a remote server?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
How to use regular expression in pattern match conditions in oracle?
What is a cursor variable?
What are group functions in oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
Is there a function to split a string in plsql?
IS it possible to built the oracle database without setting the kernal parameters?
Is there any function in oracle similar like group_concat of mysql?
How to write date and time interval literals in oracle?
How to change system global area (sga) in oracle?
How index is implemented in oracle database?
How to drop a tablespace?
How to create a single index for multiple columns?