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
- 8347 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / preethi raju
Yes it is possible by using novalidate with alter table command:
alter table table_name modify(column_with_null constraint constraint_name not null novalidate);
So the novalidate does not check the existing columns which contains the null values.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is normalisation?what are its uses?
What is the fastest query method to fetch data from the table?
What is the sql query to concatenate column values from multiple rows in oracle?
Explain what are the advantages of views?
How to use null as conditions in oracle?
Name the three major set of files on disk that compose a database in Oracle?
Can we insert data in view oracle?
What are the various oracle database objects?
What is columnar storage what is the advantage?
Can you have more than one content canvas view attached with a window ?
How to create a single index for multiple columns?
How to get a create statement for an existing table?
What is tns entry?
How do you store pictures in a database?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
