On Wed, Jul 1, 2009 at 10:58 AM, Robert
Bradshaw<[email protected]> wrote:
>
> On Jul 1, 2009, at 1:47 AM, Aleksey Gogolev wrote:
>
>> Hello!
>>
>> I need to operate on a statistical data in the sage notebook. But
>> before I do that I need to get this data from the Oracle DB. Is there
>> a way to get data from DB?
>> Cann't find the answer manually :( Any help would be appreciated.
>
> Try searching for a way to do it from Python--it's not unlikely
> someone's already written a package to do so. Alternatively, see if
> you can export the data as a text file and then parse it (again,
> using all that Python has to offer).
Indeed, Googling
oracle db python
yields numerous hits. The first hit has this example, which
obviously requires first installing some package:
import cx_Oracle
connstr='scott/tiger'
conn = cx_Oracle.connect(connstr)
curs = conn.cursor()
curs.arraysize=50
curs.execute('select 2+2 "aaa" ,3*3 from dual')
print curs.description
print curs.fetchone()
conn.close()
William
--~--~---------~--~----~------------~-------~--~----~
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sage-support
URLs: http://www.sagemath.org
-~----------~----~----~----~------~----~------~--~---
