OraFAQ Forum: Server Administration » How to create Unique Index on columns from two different tables?

Home » RDBMS Server » Server Administration » How to create Unique Index on columns from two different tables?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to create Unique Index on columns from two different tables? [message #52612]

Wed, 31 July 2002 15:45

Bismi Rahaman
Messages: 1
Registered: July 2002

Junior Member

Hi - I have two tables A(a char(1), b char(1))
and B(A number, B Char(1)).

I would like to ensure that the combination of A.a and B.a be Unique. I would like to enforce this at table level with out creating Check Constraints or Creating DataBase triggers.

Is there any ways of ensuring that the Data that goes in is Unique!

Thanks,
-Bismi

Report message to a moderator

Re: How to create Unique Index on columns from two different tables? [message #52621 is a reply to message #52612]

Thu, 01 August 2002 08:57

andrew again
Messages: 2577
Registered: March 2000

Senior Member

Interesting question - but I don't see how you can achieve it.

Report message to a moderator

Previous Topic:	Table Design Confution(URGENT)
Next Topic:	I want to move out SYSTEM objects from TEMP tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 13 10:58:13 CST 2025