Re: [cx-oracle-users] Do views have prefixes?

[Brianna L. <bri...@gm...>]

... so about five minutes after I wrote this, I finally figured out
it's called a schema, and I can get it to quote correctly by using the
right incantation of quotes as exemplified here
http://cd-docdb.fnal.gov/cgi-bin/RetrieveFile?docid=3156&version=1&filename=DjangoOracle.html
.

thanks anyway :)
Brianna


On 19 August 2010 18:47, Brianna Laugher <bri...@gm...> wrote:
> Hi again,
>
> This is probably more about Oracle than cx_Oracle, but my googling is
> not bringing me much today.
>
> There are a bunch of views that I am interested in, but to access them
> I seem to need to use an extra field to identify them. Does a field
> 'Owner' have special significance in Oracle?
>
> Why do I need to refer to the view as owner.view_name to be able to
> select data from it?
>
> What is this "owner" here? Is it a tablespace...? Some kind of prefix?
>
> The reason is that I'm trying to hook Django up to my existing
> database. In my models I can specify the database table name,
> (actually a view, but that seems to be OK), but I can't specify
> whatever the "owner" field is. Specfiying the table name as
> "$OWNER.EDIT_STATISTICS" (where $OWNER is the real value of owner, not
> the string 'owner') also does not work as the SQL escaping is not
> happy. It produces things like this:
>
> SELECT "$OWNER.EDIT_STATISTICS"."GROUP_NAME" FROM "$OWNER.EDIT_STATISTICS"
> which give a ORA-00942: table or view does not exist
>
> obviously what I need is
> SELECT "$OWNER"."EDIT_STATISTICS"."GROUP_NAME" FROM "$OWNER"."EDIT_STATISTICS"
>
> but what is this mysterious first field?
>
> thanks,
> Brianna
>
>
>>>> cursor.execute("select view_name from all_views where owner='%s'" % OWNER)
> <__builtin__.OracleCursor on <cx_Oracle.Connection to user @local>>
>>>> for c in cursor:
> ...  print c
> ...
> [...]
> ('EDIT_STATISTICS',)
> [...]
>>>> myview = 'EDIT_STATISTICS'
>>>> cursor.execute("select * from %s" % myview)
> Traceback (most recent call last):
>  File "<stdin>", line 1, in <module>
> cx_Oracle.DatabaseError: ORA-00942: table or view does not exist
>
>>>> cursor.execute("select * from %s.%s" % (OWNER, myview))
> <__builtin__.OracleCursor on <cx_Oracle.Connection to user @local>>
>
>
>
> --
> They've just been waiting in a mountain for the right moment:
> http://modernthings.org/
>



-- 
They've just been waiting in a mountain for the right moment:
http://modernthings.org/