Python and Oracle Views

Question

Can someone give me brief information about how to "connect" to an Oracle view from Python?

I looked around but couldn't anything. I'm new to Oracle DB. I will not use it I will only connect it with Python and get some info. But I have only view to connect to.

At first I thought that I can use view like below, to connect:

db = sqlalchemy.create_engine('oracle://USER:PASS@SERVER:1521/VIEW_NAME')

Then I used this:

cx_Oracle.connect(user='USER', password='PASS',
     dsn=cx_Oracle.makedsn('SERVER',1521,'VIEW_NAME'))

Then I realized that a view cannot be used as DB Name, because it is just a "tool" to only view the existing table(s).

How can I accomplish this?

David M · Accepted Answer · 2013-05-18 11:47:23Z

4

A view in an RDBMS like Oracle is essentially a "virtual" table. When querying it, you query it just like you would a table. So connect to the database/schema containing the view, and select from it as usual. The view doesn't feature in the connection details at all, just in the query.

answered May 18, 2013 at 11:47

David M

73.2k13 gold badges164 silver badges187 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

0xmtn Over a year ago

Thanks for the answer. I thought exactly like you claimed, but server that I try to connect is not mine, it is someone else's. He claimed that I can connect to view without actually connecting to db, so I tried it. ;)

Jeffrey Kemp Over a year ago

I'd prefer to call a view a "stored query" rather than a "virtual table".

David M Over a year ago

So would I - but in terms of explaining to the OP, given his question, the latter term seemed the better to clarify things to me.

Collectives™ on Stack Overflow

Python and Oracle Views

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related