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
- 6557 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 are the ways tablespaces can be managed and how do they differ?
how may join possible between (requisition with purchase order)
What do you understand by a database object?
Differentiate between pre-select and pre-query?
why dont we assign not null constraint as table level constraint.
What types of joins are used in writing subqueries?
How many types of database triggers exist?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
State any two functions of oracle?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
How can we view last record added to a table?
Explain joins in oracle?
What are operators in oracle?
How to connect asp pages to oracle servers?
How do I connect to oracle?
