Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT 'alter ' || object_type || ' ' || object_name || ' compile;'
- FROM user_objects
- WHERE STATUS <> 'VALID'
- AND object_type IN ('VIEW','SYNONYM','PROCEDURE','FUNCTION','PACKAGE','TRIGGER');
Add Comment
Please, Sign In to add comment