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

ACS3 Data Model

Description Columns Query Constraints Triggers

IM_JOB_TITLES

Columns

NameTypeNullableInsertableUpdatableDeletableComment
JOB_TITLE_IDNUMBER(38)NYESYESYES 
JOB_TITLEVARCHAR2(50.0)NYESYESYES 

Query:

select category_id as job_title_id, category as job_title
from categories
where category_type = 'Intranet Job Title'


Generated by OraSchemaDoc, (c) Aram Kananov, 2002