SQL to drop user from oracle database

[Asad]

Hi All ,

        I want to write a task which does the following logs in to oracle database using sqlplus 

SQL> select 'drop user '||username||' cascade ;' from dba_users where username like 'abc_%';

 

Execute the Drop queries Generated from the above query.

how to save output from dynamic sql and execute the in ansible playbook ?

Thanks,

--

Asad Hasan
+91 9582111698