How to execute non sql commands in python using cx_Oracle

Question

I am new to python. Could someone help me to figure out how to execute following commands using cx_Oracle in python?

I know I can use cursor.execute() for 2nd command but for other non sql commands specially 1 & 3 I am not getting any clue.

Appreciate if someone can help.

Thanks, Aravi

Why do you need to use SPOOL at all? Can't you just read the table names from the cursor into a list and then run a DROP TABLE statement for each table in the list? — Luke Woodward
– Luke Woodward, Commented Apr 8, 2014 at 19:23

Arav · Accepted Answer · 2014-04-09 12:11:19Z

1

So I achieved what I need by following way

cur.execute("SELECT table_name FROM user_tables")

result = cur.fetchall()

for row in result:

cur.execute('DROP TABLE ' + row[0] + ' CASCADE CONSTRAINTS')*

Thanks much Luke for your idea.

answered Apr 9, 2014 at 12:11

Arav

1731 gold badge1 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1