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!

UNIQUE index with case

Rosario VigilanteOct 10 2016 — edited Oct 10 2016

Hello

I have to create an Unique index only when in composite index there is a column(a4) assumes a value determined (S in my sample) otherwise with any other value, the row can be inserted

	create unique index abc_indx1 on abc_table((a1,a2,a3,
	if a4 = 's' error duplicate key
	otherwise(other values it's ok

Is there someone who can help me

Thanks in advance

This post has been answered by Chris Hunt on Oct 10 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 7 2016

Added on Oct 10 2016

9 comments

858 views