create unique index i_user_pass on users(username,password) tablespace blah;
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Jonny B" <no-mail_at_no-mail.spammers> wrote in message
news:8m3suug7pchcsgcun30vg4bcb42e5c9ka7_at_4ax.com...
> Galen Boyer wrote:
>
> >On Wed, 04 Dec 2002, no-mail_at_no-mail.spammers wrote:
> >
> >> I'd like to make a combination of the password AND username
> >> unique... Just don't know how.
> >
> >Create a unique index on the two columns.
>
> That's what i'd like to do. Any idea how its done, sample codes?
Received on Wed Dec 04 2002 - 08:46:31 CST
