[Home] [Help] [Dependency Information]
Object Name: | OLS_DIR_BUSINESSES |
---|---|
Object Type: | TABLE |
Owner: | MDSYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
Table | |
Foreign Table | Foreign Key Column | OLS_DIR_BUSINESSES | OLS_DIR_BUSINESS_CHAINS | OLS_DIR_BUSINESSES CHAIN_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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;
MDSYS.OLS_DIR_BUSINESSES is not referenced by any database object
|
|
|