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
Can multiple cursors being opened at the same time?
Explain enable novalidate constraint.
How to create a table index?
what is insert all statement in sql
Briefly explain what is literal? Give an example where it can be used?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How to check database size in Oracle?
How to select all columns of all rows from a table in oracle?
What is max rowid in oracle?
What is a data lock in oracle?
Respected sir, Please send me technical questions related to oracle apps..
What is bulk load in oracle?
How do you store pictures in a database?
Why does for update in oracle 8 cause an ora-01002 error?
How to create a testing table in oracle?