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
- 8181 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 are the attributes of the cursor?
What are the ansi data types supported in oracle?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
What is the implicit cursor in oracle?
What is a cursor variable?
Can you have more than one content canvas view attached with a window ?
How oracle handles dead locks?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
How to best split csv strings in oracle 9i?
How to insert a new row into a table in oracle?
Can a formula column be obtained through a select statement ?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How to export your own schema?
What are the oracle differences between nvl and coalesce
