Home » RDBMS Server » Server Administration » Help with " Adding Constraint" script
Help with " Adding Constraint" script [message #375193] Fri, 03 August 2001 08:49 Go to next message
Arpit
Messages: 99
Registered: March 2001
Member
Hi,

Can somebody please help me to add a constraint on my "Contact" table.

I need to add a constraint on the Contact table for the 'Postal Zip Code' colum to allow the users to enter postal code in 'CNC NCN' format only. where C - Character and N- Number.

Because number of times users enter 'O' instead of 0 .

Please help. Any help on this would highly be appreciated.

Thanks!

Report message to a moderator

Re: Help with " Adding Constraint" script [message #375195 is a reply to message #375193] Fri, 03 August 2001 09:01 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
hi,
Write database trigger on contact table..

Suresh

Report message to a moderator

Previous Topic: Why varchar2 not varchar?
Next Topic: Re: How to change column name of any table in oracle without modifying actual table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 10:48:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.