SURVSIMP_RESPONSES_UNIQUE
Columns
Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
---|
RESPONSE_ID | NUMBER(38) | N | YES | YES | YES | |
SURVEY_ID | NUMBER(38) | N | YES | YES | YES | |
SCOPE | VARCHAR2(20.0) | Y | YES | YES | YES | |
USER_ID | NUMBER(38) | Y | YES | YES | YES | |
GROUP_ID | NUMBER(38) | Y | YES | YES | YES | |
TITLE | VARCHAR2(100.0) | Y | YES | YES | YES | |
SUBMISSION_DATE | DATE | N | YES | YES | YES | |
IP_ADDRESS | VARCHAR2(50.0) | Y | YES | YES | YES | |
NOTIFY_ON_COMMENT_P | CHAR(1.0) | Y | YES | YES | YES | |
PROPOSAL_STATE | VARCHAR2(30.0) | Y | YES | YES | YES | |
Query:
select r1.* from survsimp_responses r1
where r1.response_id=(select max(r2.response_id)
from survsimp_responses r2
where r1.survey_id=r2.survey_id
and r1.user_id=r2.user_id)
Generated by OraSchemaDoc,
(c) Aram Kananov, 2002