Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE PROCEDURE engineering_all ( idx IN NUMBER )
- IS
- tempstmt VARCHAR2(2000);
- BEGIN
- create_table_like( 'results_temp', 'results', 1);
- tempstmt := 'ALTER TABLE results_temp CACHE';
- EXECUTE IMMEDIATE tempstmt;
- engineering('CONSERVATIVE', idx);
- engineering('INTERMEDIATE', idx);
- engineering('AGGRESSIVE', idx);
- END;
- /
Add Comment
Please, Sign In to add comment