Guest User

Untitled

a guest
Jun 19th, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. CREATE OR REPLACE PROCEDURE engineering_all ( idx IN NUMBER )
  2. IS
  3. tempstmt VARCHAR2(2000);
  4. BEGIN
  5. create_table_like( 'results_temp', 'results', 1);
  6.  
  7. tempstmt := 'ALTER TABLE results_temp CACHE';
  8. EXECUTE IMMEDIATE tempstmt;
  9.  
  10. engineering('CONSERVATIVE', idx);
  11. engineering('INTERMEDIATE', idx);
  12. engineering('AGGRESSIVE', idx);
  13. END;
  14. /
Add Comment
Please, Sign In to add comment