Oracle RDBMS table access

[Robert J.M. Edis]

Thanks Bob, that did the trick!

As I could access these tables using sqlplus and the same account/password
as the PHD was using, I assumed I didn't need any prefix.  All is well now.
:)

Thanks to Pankaj and Brian for their insite too.

Blue

-----Original Message-----
From: Cheek Bob
To: Robert J.M. Edis; 'powerh-l@list.swau.edu'
Sent: 1/19/00 1:16 PM
Subject: RE: Oracle RDBMS table access

Blue,

The owner in the dictionary for the database is probably different.
What
will work is if you preface it with the word public.

For example:
Quiz
Access public.all_tab_columns
> show items

                                             INPUT OUTPUT
ALL_TAB_COLUMNS                         TYPE SCALE SCALE  DEC PICTURE
  OWNER                                 VARCHAR               X(30)
  TABLE_NAME                            VARCHAR               X(30)
  COLUMN_NAME                           VARCHAR               X(30)
  DATA_TYPE                             VARCHAR               X(30)
  DATA_TYPE_MOD                         VARCHAR               X(3)
  DATA_TYPE_OWNER                       VARCHAR               X(30)
  DATA_LENGTH                           NUM     0     0    0
^,^^^,^^^,^...
  DATA_PRECISION                        NUM     0     0    0
^,^^^,^^^,^...
  DATA_SCALE                            NUM     0     0    0
^,^^^,^^^,^...
  NULLABLE                              VARCHAR               X(1)
  COLUMN_ID                             NUM     0     0    0
^,^^^,^^^,^...
  DEFAULT_LENGTH                        NUM     0     0    0
^,^^^,^^^,^...
  DATA_DEFAULT                          BLOB
  NUM_DISTINCT                          NUM     0     0    0
^,^^^,^^^,^...
  LOW_VALUE                             VARCHAR               X(32)
  HIGH_VALUE                            VARCHAR               X(32)
  DENSITY                               NUM     0     0    0
^,^^^,^^^,^...
  NUM_NULLS                             NUM     0     0    0
^,^^^,^^^,^...
  NUM_BUCKETS                           NUM     0     0    0
^,^^^,^^^,^...
  LAST_ANALYZED                         DATETIME              MM/DD/YY
  SAMPLE_SIZE                           NUM     0     0    0
^,^^^,^^^,^...
  CHARACTER_SET_NAME                    VARCHAR               X(44)
  CHAR_COL_DECL_LENGTH                  NUM     0     0    0
^,^^^,^^^,^...



	-----Original Message-----
	From:	Robert J.M. Edis [SMTP:robert.edis@creatcomp.com]
	Sent:	Wednesday, January 19, 2000 12:40 PM
	To:	'powerh-l@list.swau.edu'
	Subject:	Oracle RDBMS table access

	G'day all

	I can use PH to access data tables in an Oracle 7.3.4 database
but
not the
	'special' tables such as all_tab_columns.  Why?

	Blue
	= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
= =
= = = =
	Subscribe: "subscribe powerh-l" in message body to
majordomo@lists.swau.edu
	Unsubscribe: "unsubscribe powerh-l" in message to
majordomo@lists.swau.edu
	This list is closed, thus to post to the list, you must be a
subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.