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
- 7971 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
What is a named program unit?
How do I uninstall oracle 11g?
How to generate query output in html format?
What is blob data type in oracle?
Is it possible to insert comments into sql statements return in the data model editor ?
How to create a stored function in oracle?
How to Truncate Table in Oracle
how to do daily transactions with out sql* loader control file regesterd in apps?
What operating systems are supported by oracle database 10g xe?
How do you bind variables in oracle?
Point the difference between translate and replace?
what's query optimization and without use of IN AND Exist can we get another way data from query
How to compare dates in oracle sql?
What is memory advisor in Oracle?
What is a nested table and how is it different from a normal table?
