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
- 8357 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 the quickest way to export a table to a flat file?
What is oracle update statement with inner join ?
What are the components of logical database structure in oracle database?
query optmization techniques and quwry analyser+projects+ppts
Describe an oracle table?
What is control file used for?
How a database is related to tablespaces?
How to drop an index?
Explain the use of log option in exp command.
What are set operators?
What are the types of partitions in oracle?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
How to loop through data rows in the implicit cursor?
How to define a specific record type?
What are the uses of Database Trigger ?
