I'm a python newbie, using the
cursor.execute("select tablespace_name from user_tablespaces")
tablespaceNames = 
for result in cursor:
You are slicing the tuples that represent each retrieved row rather than the strings that are the first (and only) elements of those rows. Further, you don't need to "get rid of the quotes" - that's just the interpreter doing its best to represent the data structure.
Your database returns the equivalent of the structure below - a list of tuples. Since you only selected a single field, each tuple only contains one element.
data = [ ('SYSTEM',), ('SYSAUX',), ('UNDOTBS1',), ('TEMP',), ('USERS',) ]
So first let's extract those single elements to give ourselves a list of strings instead of a list of tuples.
sdata = [s for s in data] print(sdata)
The output you will see is
['SYSTEM', 'SYSAUX', 'UNDOTBS1', 'TEMP', 'USERS']
Then print out each of the strings in the tuple:
for s in sdata: print(s)
The output from this code is
SYSTEM SYSAUX UNDOTBS1 TEMP USERS
See - no quotes!