CLASSIFIED_CONTEXT_VIEW
Columns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| CLASSIFIED_AD_ID | NUMBER(38) | N | YES | YES | YES | |
| DOMAIN_ID | NUMBER(38) | N | YES | YES | YES | |
| ONE_LINE | VARCHAR2(150.0) | Y | YES | YES | YES | |
| EXPIRES | DATE | Y | YES | YES | YES | |
| INDEXED_STUFF | VARCHAR2(4000.0) | Y | NO | NO | NO | |
Query:
select ca.classified_ad_id, ca.domain_id, ca.one_line, ca.expires, ca.one_line || ' ' || ca.full_ad || ' ' || u.email || ' ' || u.first_names || ' ' || u.last_name || ' ' || ca.manufacturer || ' ' || ca.model || ' ' as indexed_stuff
from classified_ads ca, users u
where ca.user_id = u.user_id
Generated by OraSchemaDoc,
(c) Aram Kananov, 2002