krupananda


{ City } hyderabad
< Country > india
* Profession * swe
User No # 75216
Total Questions Posted # 1
Total Answers Posted # 1

Total Answers Posted for My Questions # 2
Total Views for My Questions # 4865

Users Marked my Answers as Correct # 4
Users Marked my Answers as Wrong # 1
Questions / { krupananda }
Questions Answers Category Views Company eMail

how can we write trigger in trigger???????? can we write one trigger on two table???

Value Labs,

2 Oracle General 4865



Answers / { krupananda }

Question { Cap Gemini, 6544 }

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?


Answer

It is not possible to add not null constraint on existing
column which contains null values.
but we can add not null constraint from 101 record onwards
using triggers.

using triggers it is possible to restrict not null values

Is This Answer Correct ?    4 Yes 1 No