Home » SQL & PL/SQL » SQL & PL/SQL » trigger or constraint
trigger or constraint [message #1111] Tue, 02 April 2002 05:54 Go to next message
Susan
Messages: 102
Registered: October 2001
Senior Member
Hello,

We have a table with master_id field. I want to limit data entry to a unique master_id. Can I do this with a trigger or check constraint?

Report message to a moderator

Re: trigger or constraint [message #1112 is a reply to message #1111] Tue, 02 April 2002 07:22 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You can use any of them.
Using a constraint is recomended though!

Report message to a moderator

Previous Topic: Re: Help needed with UTL_SMTP
Next Topic: How to change the SQL prompt in SQL* Plus??
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 11:21:05 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.