April 18, 2006
Producing a CSV file from a database table
Back in November, 2002 I wrote a little utility module to dump the entire contents of an Oracle table to a CSV file.
Over the past month or so I've needed it again so I dusted that code off and made some enhancements. First I added support for MySQL and SQLite. As if that wasn't enough I then added an optional where clause parameter, so that you can dump some of the rows in the table. Then I added another optional parameter, this time a column list allowing you to only specify a subset of the columns in the table.
Then I just got carried away and introduced another function which accepts a valid SQL statement and dumps its results to a CSV file.
You can view the code here - csvDump.py or download it from here - csvDump.py.
Posted by Andy Todd at 06:14 PM | Comments (0)
April 13, 2006
Multi Language Oracle Applications
Dear Lazyweb,
Do any of the fine readers of this blog know of any organisations that have implemented Oracle Applications in more than a couple of languages? I'm slightly involved in a European implementation and they are talking about having 15 (yes fifteen) functional languages. Endeavours to procure a reference site, or even anything approaching useful information, from Oracle have so far yielded very little of use.
I'm particularly interested in implementation and support war stories. Information on which languages are well supported and which to avoid will also be very welcome.
Can anyone help? Or point me in the direction of someone can? For those fixated on geography the company are based in Australia but the implementation project is being done from the UK.
Posted by Andy Todd at 12:33 PM | Comments (0)