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
- 8143 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
Where do we use decode and case statements?
How to check your oracle database 10g xe installation?
How to drop a tablespace?
What is private procedure oracle?
Explain user account with reference to oracle.
What is instant client oracle?
How to change user password in oracle?
why dont we assign not null constraint as table level constraint.
Which environment variables are absolutely critical in order to run the OUI?
How to select some columns from a table in oracle?
What are ddl statements in oracle?
how to handle exceptions in post production
What is redo log?
What is oracle in java?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
