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
- 6531 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
What is oracle datasource?
Explain the use of log option in exp command.
What is translate in oracle?
What are the different editions of oracle?
How to start a new transaction in oracle?
What the is the diff between local index and global index. give some example.
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What is difference between cartesian join and cross join?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How do I start tns listener?
How to apply filtering criteria at group level in oracle?
What is the recommended interval at which to run statspack snapshots, and why?
What is the difference between view and materialized view in Oracle?
What is a package ? What are the advantages of package ?
What is a directory object?
