You are here:

Oracle/Default Constraint

Advertisement


Question
Will you please help me to implement Default constraint for multiple columns using alter statement.

Thank you in advance.

Answer
Hi Saravanan,

Not understanding your business requirements, I can point you to several good references on creating constraints and its management:

http://www.databasedesign-resource.com/oracle-constraints.html

http://www.dba-oracle.com/t_constraints.htm

http://www.adp-gmbh.ch/ora/misc/integrity_constraints.html

Hope this helps.

Peter

Oracle

All Answers


Answers by Expert:


Ask Experts

Volunteer


Peter Choi

Expertise

I am a senior Oracle DBA, PeopleSoft HCM specialist and Project Manager with 15+ years experience. I have been working with PeopleSoft (HRMS/HCM 5, 7, 7.x and 8.9, 9.x), Oracle RDBMS (7.3 - 11gR2) on various Unix and MS-Windows platforms, and some Oracle Application Server (9i - 11gR1). I also have experience with the configuration and administration of PeopleSoft's Internet Architecture (PIA) and the Oracle 11g Fusion Middleware and Oracle Business Intelligence (OBI).

©2012 About.com, a part of The New York Times Company. All rights reserved.