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
- 8134 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 database client?
What is the use of aggregate functions in oracle?
List out the types of joins.
What is meant by joins?
How does Oracle guarantee data integrity of data changes?
How will you differentiate between varchar & varchar2?
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.
Why we use bulk collect in oracle?
Where are the settings stored for each instance in oracle?
Differentiate between function and procedure in oracle.
What is the recommended interval at which to run statspack snapshots, and why?
What is bind variable in oracle 11g?
When system tablespace is created?
What are the uses of a database trigger?
How to view the data files in the current database?
