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

ACS3 Data Model
Description Columns Query Constraints Triggers

IM_PROJECT_TYPES

Columns

NameTypeNullableInsertableUpdatableDeletableComment
PROJECT_TYPE_IDNUMBER(38)NYESYESYES 
PROJECT_TYPEVARCHAR2(50.0)NYESYESYES 

Query:

select category_id as project_type_id, category as project_type
from categories
where category_type = 'Intranet Project Type'

Generated by OraSchemaDoc, (c) Aram Kananov, 2002