December 2006
3 posts
1 tag
Information about Oracle Directories
I know what I write is quite newbieish, but I needed information about a directory I’ve created, means which path it’s pointing to:
select * from all_directories dir;
There simply is no user_directories, and with all_objects I didn’t get what I wanted.
2 tags
Excel to CSV with Python
I wanted to handle a simple task: convert a bunch of XSLs to CSVs. Well I wrote a small Script in VBScript and it worked. Then I needed to change the List separator, so I did that in my System settings, and then my Script didn’t work anymore, because it just ignored my changed settings.
I googled a lot and didn’t find the solution (only people with the same problem). It seems that...
3 tags
SQL Start-Script generator
Sometimes it’s so simple:
import glob
files = glob.glob('*.*');
f=open('start_script.sql', 'w')
f.write('PROMPT This is an automatic generated start script\n');
f.write('PROMPT\n');
f.write('SPOOL start_script.LOG\n\n');
for filename in files:
if filename == 'start_script.sql':
continue
f.write('PROMPT Starting script ' + filename + '\n');
f.write('@@' + filename +...