STOLEN_REGISTRY_FOR_CONTEXT
Columns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| STOLEN_ID | NUMBER(38) | N | YES | YES | YES | |
| DELETED_P | CHAR(1.0) | Y | YES | YES | YES | |
| RECOVERED_P | CHAR(1.0) | Y | YES | YES | YES | |
| MANUFACTURER | VARCHAR2(50.0) | Y | YES | YES | YES | |
| MODEL | VARCHAR2(100.0) | Y | YES | YES | YES | |
| SERIAL_NUMBER | VARCHAR2(100.0) | Y | YES | YES | YES | |
| INDEXEDTEXT | VARCHAR2(3556.0) | Y | NO | NO | NO | |
Query:
SELECT stolen_id, s.deleted_p, recovered_p, manufacturer, model, serial_number, serial_number || ' ' || u.first_names || ' ' || u.last_name || ' ' || u.email || ' ' || manufacturer || ' ' || model || ' ' || story
FROM stolen_registry s, users u
WHERE u.user_id = s.user_id
Generated by OraSchemaDoc,
(c) Aram Kananov, 2002