DECLARE
pass VARCHAR2(20) := 'Z1234';--????
BEGIN
FOR c IN (select a.username from dba_users a,icaps_user b where 'Z'||b.username=a.username ) LOOP
EXECUTE IMMEDIATE 'alter user ' || c.username || ' identified by ' || pass;
END LOOP;
END;
#!/usr/bin/env python
import smtplib,mimetypes
from email import Encoders
from email.MIMEBase import MIMEBase
from email.MIMEText import MIMEText
from email.MIMEMultipart import MIMEMultipart
import email
import time
femail='xxx@xxxx.com'
temail =['yyyyy@yyyy.com','sssss@ssss.com']
ccmail=['zzzzz@zzzzz.com','ggggg@ggggg.com']
to_string =''
for item in temail:
to_string += item +','
cc_strin