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
- 8182 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to retrieve the count of updated rows?
What is oracle datasource?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How to do a full database export?
How to resolve name conflicts between variables and columns?
what is the difference between substr and instr function in oracle?
What is a sub query and what are the different types of subqueries?
What is raw datatype?
How to retrieve values from data fields in record variables?
Which is better Oracle or MS SQL? Why?
What is recovery manager(rman) backup in Oracle?
Is java required for oracle client?
What are the most common interview questions on ETL Testing for experience?
How to update values on multiple rows in oracle?
Explain the use of online redo log files in oracle.
