RHN_CONTACT_MONITORING
DDL scriptColumns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| RECID | NUMBER(38) | N | NO | NO | NO | |
| CUSTOMER_ID | NUMBER(38) | N | NO | NO | NO | |
| CONTACT_LAST_NAME | VARCHAR2(128) | N | YES | YES | YES | |
| CONTACT_FIRST_NAME | VARCHAR2(128) | N | YES | YES | YES | |
| EMAIL_ADDRESS | VARCHAR2(4000) | Y | NO | NO | NO | |
| USERNAME | VARCHAR2(64) | N | NO | NO | NO | |
| PASSWORD | VARCHAR2(38) | N | NO | NO | NO | |
| SCHEDULE_ID | NUMBER(38) | Y | NO | NO | NO | |
| PREFERRED_TIME_ZONE | CHAR(3) | Y | NO | NO | NO | |
Query:
Legend: string keyword reserved word operator
select u.id recid,
u.org_id customer_id,
wupi.last_name contact_last_name,
wupi.first_names contact_first_name,
rhn_user.find_mailable_address(u.id)
email_address,
u.login username,
u.password password,
1 schedule_id,
'GMT' preferred_time_zone
from
web_user_personal_info wupi,
web_contact u
where 1=1
and u.id = wupi.web_user_id