SQL to drop user from oracle database

1 view
Skip to first unread message


Feb 23, 2023, 7:18:11 AMFeb 23
to ansibl...@googlegroups.com
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 ?

Asad Hasan
+91 9582111698
Reply all
Reply to author
0 new messages