Tagged Questions
0
votes
1answer
180 views
Stored Procedure Create Table from Variable with Variable Constraint
I have managed use a store procedure to create a copy of a table with a variable name. But I am struggling to understand how to incorporate a constraint into the stored procedure.
The problem:
The ...
1
vote
2answers
445 views
Oracle Procedure to Enable/Disable all constraints
I have this nice piece of code:
begin
for i in
(
select constraint_name, table_name
from user_constraints
where constraint_type ='R'
and status = 'ENABLED'
) LOOP
execute immediate ...
2
votes
2answers
171 views
Proper use of NULL, and utilizing CHECK constraints for business logic vs stored procedures
This question regards the proper use of NULL and utilizing CHECK constraints for business logic vs stored procedures.
I have the following tables setup.
I normalized the tables to avoid using ...
