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
- 7975 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
How to connect to the server with user account: sys?
What is a synonym? What are its various types?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
How to list all indexes in your schema?
What is the usage of merge statement?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How to rename a tablespace in oracle?
What is flashback in Oracle?
What is a select query statement in oracle?
What is the difference between substr and instr?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How to get last row id?
What is tns entry?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
