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?

June 06, 2009 08:17:46	#5
gdurga	Member Since: June 2009 Total Comments: 4
RE: Default Constraint
A coulumn can be given a default value by using DEFAULT option. This option prevents null values from entering the column if a row is inserted with out a value in to the table. Ex: ....... Hire_date DATE DEFAULT SYSDATE, .......