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?

Answers were Sorted based on User's Feedback



In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL v..

Answer / 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

In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL v..

Answer / sudipta santra

Yes, Krupananda, U r very right..I am explainning the trigger:

Create or replace trigger bri_tab_101_rec
before insert on table1
for each row

declare
usr_ins_excep exception;
begin
if :new.column4 is null then
raise usr_ins_exception;
end if;
exception
when usr_ins_excep
<< do exception code>>
rollback;
end;

Is This Answer Correct ?    4 Yes 0 No

In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL v..

Answer / 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

In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL v..

Answer / preethi raju

Yes it is possible by using novalidate with alter table command:

alter table table_name modify(column_with_null constraint constraint_name not null novalidate);

So the novalidate does not check the existing columns which contains the null values.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Oracle General Interview Questions

Describe the different type of Integrity Constraints supported by ORACLE ?

2 Answers  


how to insert the image in table

2 Answers  


Name the various constraints used in oracle?

0 Answers  


How to Identify the previously inserted/updated records in already populated table.

0 Answers  


What are the differences between interval year to month and interval day to second?

0 Answers  


What is raw datatype in oracle?

0 Answers  


What is the order of defining local variables and sub procedures/functions?

0 Answers  


write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000

4 Answers   TCS,


What is snapshot is too old? Give and example for better understand.

0 Answers   TCS,


Is there a combination of "like" and "in" in sql?

0 Answers  


What are various joins used while writing SUBQUERIES?

2 Answers  


What is an oracle function?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)