Our Oracle Databases require connections every 30 days. Generate script from list of connections to automatically log in, select * from Dual; , then exit.

Our Databases require logins every 30 days. I literally have 100's of connections. We must reset our application and user passwords every 90 to 180 days.  I use TOAD every day, at least an hour a day. I would like scripts to do the following

1. Log in, SELECT * FROM DUAL;, then exit for all the TOAD connections.

2. based on criteria, reset the password to all the connections as a bulk reset.