HELP: Creating constraints in code
From: Morgan Skinner <skinner_at_kirk.fisons-ls.com>
Date: 1995/05/01
Message-ID: <3o3edv$agt_at_alterdial.UU.NET>#1/1
Date: 1995/05/01
Message-ID: <3o3edv$agt_at_alterdial.UU.NET>#1/1
Anyone know how to do the following SQL in a stored procedure by directly executing it using one of the Oracle calls?. As it's DML stuff I cannot just type it into a proc and execute it.
ALTER TABLE this
ADD CONSTRAINT that
FOREIGN KEY (something)
REFERENCES something (somewhere);
I want to do this in PL/SQL. Any help will be appreciated. Received on Mon May 01 1995 - 00:00:00 CEST