Answer Detail: RE: Default Constraint

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Print |

Question: Default Constraint

Answer: What is default constraint? How we you apply it?

September 09, 2008 15:01:34	#2
hamsatharini	Member Since: September 2008 Total Comments: 2
RE: Default Constraint
It specifies a default value for a new column or a new default for an existing column. Oracle assigns this value to the column if a subsequent INSERT statement omits a value for the column. A DEFAULT expression cannot contain references to other columns, the pseudocolumns CURRVAL, NEXTVAL, LEVEL, and ROWNUM, or date constants that are not fully specified.