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
- 8340 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
Explain the use of online redo log files in oracle.
How to rebuild an index in oracle?
Explain integrity constraints?
How to create a temporary table in oracle?
How do I limit the number of rows returned by an oracle query after ordering?
How to write numeric literals in oracle?
What are the different types of synonyms?
How to increment dates by 1 in oracle?
What is the Tune Query
Is it possible to split the print reviewer into more than one region ?
How to load data from external tables to regular tables?
How to rename a tablespace in oracle?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
what are actual and formal parameters?
How to delete all rows a table in oracle?
