NEXTSTEP

Title: Using EOModeler with Oracle - Specifying Query for Tables

Entry Number:  
Last Updated: 31 Mar 1995
Document Revision:

Keywords: EOModeler, Oracle

Questions

Q: I want to see all the tables I have access to, but EOModeler doesn't list them all. Why?
Answers

A:  By default, the Oracle7 adaptor will only show the tables that you own, not all of the tables that you have access to. So, in order to get all the tables that you own, you can specify the following dwrite:

dwrite Oracle7Adaptor OracleTableNamesSQL "select object_name from user_objects where object_type in ('TABLE', 'VIEW', 'SYNONYM')"

Valid for:  EOF 1.1, NEXTSTEP 3.2 Developer, NEXTSTEP 3.3 Developer

See Also:
/NextDeveloper/Headers/eoadaptors/Oracle7/OracleDescription.h