Tim Bunce wrote:
>
> On Tue, Mar 19, 2002 at 04:41:33PM +0100, Steffen Goeldner wrote:
> > Thus, I'd better change:
> >
> > , decode( t.OWNER, 'PUBLIC', '', t.OWNER ) TABLE_SCHEM
> >
> > to
> >
> > , t.OWNER TABLE_SCHEM
> >
> > ?
>
> Yesp, looks like it.
Done (see attachement).
Should I add 'PUBLIC' to the enumeration of schemas, e.g.:
SELECT NULL TABLE_CAT
, s TABLE_SCHEM
, NULL TABLE_NAME
, NULL TABLE_TYPE
, NULL REMARKS
FROM
(
SELECT USERNAME s FROM ALL_USERS
UNION
SELECT 'PUBLIC' s FROM DUAL
)
ORDER BY 2
Steffen
*** DBD-Oracle-1.12.orig\Oracle.pm Fri Aug 31 18:27:18 2001
--- Oracle.pm Tue Mar 19 20:40:45 2002
***************
*** 371,377 ****
FROM
(
SELECT NULL TABLE_CAT
! , decode( t.OWNER, 'PUBLIC', '', t.OWNER ) TABLE_SCHEM
, t.TABLE_NAME TABLE_NAME
, t.TABLE_TYPE TABLE_TYPE
, c.COMMENTS REMARKS
--- 371,377 ----
FROM
(
SELECT NULL TABLE_CAT
! , t.OWNER TABLE_SCHEM
, t.TABLE_NAME TABLE_NAME
, t.TABLE_TYPE TABLE_TYPE
, c.COMMENTS REMARKS
***************
*** 872,879 ****
The special enumerations of catalogs, schemas and table types are
supported. However, TABLE_CAT is always NULL.
-
- The schema name for PUBLIC database objects is an empty string.
An identifier is passed I<as is>, i.e. as the user provides or
Oracle returns it.
--- 872,877 ----
