- Install Oracle XE from Oracle's own repository of .deb files
sudo apt-get install python-dev python-setuptools
sudo -E easy_install cx_Oracle
The -E flag carries your environment variables into your sudo session; if you omit it, you may get a
cannot locate an Oracle software installationerror.
>>> import cx_Oracle
>>> cnxn = cx_Oracle.connect('system/mysystempassword@xe')
>>> crsr = cnxn.cursor()
>>> crsr.execute('SELECT * FROM dual')
Thursday, June 12, 2008
Simplifying options have appeared since the last time I posted about installing cx_Oracle against Oracle XE on Ubuntu, so I thought I'd produce an updated, simplified summary.
Monday, June 09, 2008
I just keep having fun with cmd2 (and with sqlpython, which is built on cmd2 and inherits its goodies). The latest:
- If you use
>to redirect output and omit a destination filename, your output will go into the paste buffer. Then you can Ctrl-V and paste it into any window.
- You can use the pipe symbol (
|) just like in Unix, to redirect output into any shell command.