Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to add multiple constraints

Stanley Lee-OracleDec 16 2010 — edited Dec 16 2010
Hi,

I would like to alter the table to add multiple constraints. Can it be done in one statement or I have to have multiple statements? Thanks.

alter table
table_name
add constraint
constraint_1,
add constraint
constraint_2
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 13 2011
Added on Dec 16 2010
2 comments
23,543 views