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
- 8348 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
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What is the scope of a local variable?
How to apply filtering criteria at group level in oracle?
How remove data files before opening a database?
What are the oracle differences between nvl and coalesce
Why cursor variables are easier to use than cursors?
why dont we assign not null constraint as table level constraint.
Please explain oracle data types with examples?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
How do you store pictures in a database?
Can group functions be mixed with non-group selection fields?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is the dynamic sql in oracle?
What are the data types in oracle?
How to display employee records who gets more salary than the average salary in the department?
