Main Tables Views Indexes Constraints Triggers Procedures Functions Packages Sanity check Index

ACS3 Data Model

Description Columns Query Constraints Triggers

IM_CUSTOMER_TYPES

Columns

NameTypeNullableInsertableUpdatableDeletableComment
CUSTOMER_TYPE_IDNUMBER(38)NYESYESYES 
CUSTOMER_TYPEVARCHAR2(50.0)NYESYESYES 

Query:

select category_id as customer_type_id, category as customer_type
from categories
where category_type = 'Intranet Customer Type'


Generated by OraSchemaDoc, (c) Aram Kananov, 2002