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
- 6538 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / manish kumar
this is not possible we can't create Not Null Constraint in
this column. b'case existing record in column is already
null so oracle through
error: null record found.
| Is This Answer Correct ? | 15 Yes | 2 No |
Post New Answer View All Answers
Give syntax for SQL and ORACLE joins.
What is an oracle database table?
what is normalisation?what are its uses?
what is the difference between restoring and recovering?
What do you mean by cdb and pdb in oracle 12c?
How to define and use table alias names in oracle?
Explain about integrity constraint?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
What is an external table?
What are a query and state the different types of queries and their uses?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How to divide query output into groups in oracle?
What are temporal data types in oracle?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What are the differences between blob and clob in oracle?
