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
- 8022 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 using clause and give example?
Why oracle is used?
Give the various exception types.
How do you find current date and time in oracle?
What is a cursor and what are the steps need to be taken?
What is a named program unit?
What is a database table in oracle?
What are the extensions used by oracle reports?
What is Reduced List of Values?
List the types of joins used in writing subqueries?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How to use an explicit cursor without open statements?
Is oracle an open source?
What is transaction control statement and how many types of transaction control statement in Oracle?
What is the difference between $oracle_base and $oracle_home?
