eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: MDSYS.OLS_DIR_BUSINESSES

Object Details

Object Name:	OLS_DIR_BUSINESSES
Object Type:	TABLE
Owner:	MDSYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSAUX
PCT Free:	10
PCT Used:

Primary Key: SYS_C00246983

BUSINESS_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_C00246983	NORMAL	UNIQUE	SYSAUX	BUSINESS_ID
SYS_IL0000635040C00017$$	LOB	UNIQUE	SYSAUX
SYS_IL0000635040C00024$$	LOB	UNIQUE	SYSAUX
SYS_IL0000635040C00025$$	LOB	UNIQUE	SYSAUX

Foreign Keys

Table		Foreign Table	Foreign Key Column
OLS_DIR_BUSINESSES		OLS_DIR_BUSINESS_CHAINS	OLS_DIR_BUSINESSES CHAIN_ID

Columns

Name	Datatype	Length	Mandatory
BUSINESS_ID	NUMBER		Yes
BUSINESS_NAME	VARCHAR2	(128)	Yes
CHAIN_ID	NUMBER
DESCRIPTION	VARCHAR2	(1024)
PHONE	VARCHAR2	(64)
COUNTRY	VARCHAR2	(64)	Yes
COUNTRY_SUBDIVISION	VARCHAR2	(128)
COUNTRY_SECONDARY_SUBDIV	VARCHAR2	(128)
MUNICIPALITY	VARCHAR2	(128)
MUNICIPALITY_SUBDIVISION	VARCHAR2	(128)
POSTAL_CODE	VARCHAR2	(32)	Yes
POSTAL_CODE_EXT	VARCHAR2	(32)
STREET	VARCHAR2	(128)	Yes
INTERSECTING_STREET	VARCHAR2	(128)
BUILDING	VARCHAR2	(64)
PARAMETERS	XMLTYPE	(2000)
GEOM	SDO_GEOMETRY	(1)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BUSINESS_ID
,      BUSINESS_NAME
,      CHAIN_ID
,      DESCRIPTION
,      PHONE
,      COUNTRY
,      COUNTRY_SUBDIVISION
,      COUNTRY_SECONDARY_SUBDIV
,      MUNICIPALITY
,      MUNICIPALITY_SUBDIVISION
,      POSTAL_CODE
,      POSTAL_CODE_EXT
,      STREET
,      INTERSECTING_STREET
,      BUILDING
,      PARAMETERS
,      GEOM
FROM MDSYS.OLS_DIR_BUSINESSES;

Dependencies

[top of page]

MDSYS.OLS_DIR_BUSINESSES references the following:

MDSYS: SDO_ELEM_INFO_ARRAY; SDO_GEOMETRY; SDO_ORDINATE_ARRAY
PUBLIC: XMLTYPE
SYS: STANDARD - show dependent code; XMLTYPE

MDSYS.OLS_DIR_BUSINESSES is not referenced by any database object