TICKET_CODES
Columns
Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
---|
CODE_SET | VARCHAR2(20.0) | N | YES | YES | YES | |
CODE_ID | NUMBER(38) | N | NO | NO | NO | |
CODE_TYPE | VARCHAR2(20.0) | Y | NO | NO | NO | |
CODE | VARCHAR2(100.0) | N | NO | NO | NO | |
CODE_LONG | VARCHAR2(400.0) | N | NO | NO | NO | |
CODE_SEQ | NUMBER(38) | N | NO | NO | NO | |
CODE_HELP | VARCHAR2(4000.0) | Y | NO | NO | NO | |
Query:
select tcs.code_set,
tci.code_id,
tci.code_type,
tci.code,
tci.code_long,
tci.code_seq,
tci.code_help
from ticket_codes_i tci, ticket_code_sets tcs
where tcs.code_id = tci.code_id
Generated by OraSchemaDoc,
(c) Aram Kananov, 2002