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
- 6539 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 select some rows from a table in oracle?
How to get maxsal , minsal, ename department wise in single query
how to clone 9i Database on to 10g Database.
When do I need to use a semicolon vs a slash in oracle sql?
How data locks are respected in oracle?
Is a rollback possible to any savepoint?
How to create a new tablespace in oracle?
What is the dynamic sql in oracle?
How to save query output to a local file?
What is hot backup and logical backup?
What is the difference between count (*), count (expression), count (distinct expression)?
What is memory advisor in Oracle?
Can multiple columns be used in group by in oracle?
What is a user account in oracle?
Explain the use of grant option in exp command.
