Home » SQL & PL/SQL » SQL & PL/SQL » Constaint creation
Constaint creation [message #23456] Tue, 10 December 2002 23:46 Go to next message
Malti
Messages: 3
Registered: November 2002
Junior Member
I want to create new constraint or i want to enable existing constraint which is disabled on a table but this constraint should not validate existing data in table... can anyone help me in creating such constraint..

Report message to a moderator

Re: Constaint creation [message #23458 is a reply to message #23456] Wed, 11 December 2002 00:16 Go to previous message
Todd Barry
Messages: 2
Registered: August 2002
Junior Member
Check out the ENABLE NOVALIDATE syntax:

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:374147165166

Report message to a moderator

Previous Topic: output to printer?
Next Topic: cascade
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 15 18:02:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.