OraFAQ Forum: SQL & PL/SQL » How Many unique constraints can be allowed for a Table?

Home » SQL & PL/SQL » SQL & PL/SQL » How Many unique constraints can be allowed for a Table? (Oracle 10 G)

Wed, 18 June 2008 07:08

rangan.s
Messages: 75
Registered: February 2008
Location: chennai

Member

How Many unique constraints can be allowed for a Table?

Wed, 18 June 2008 07:11

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The number of combinations of different columns of the table.

Regards
Michel

Wed, 18 June 2008 07:50

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Even more than that, if you're on 10g.

You can create unique function based indexes to enforce additional uniqueness constraints.

Documentation

Wed, 18 June 2008 08:24

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes, I forgot FBI.

Regards
Michel

Previous Topic:	Regular expression
Next Topic:	Suggest for Error

Goto Forum:

]

Current Time: Tue Dec 03 14:33:57 CST 2024