RHNWEBCONTACTENABLED
DDL scriptColumns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| ID | NUMBER(38) | Y | NO | NO | NO | |
| ORG_ID | NUMBER(38) | Y | NO | NO | NO | |
| LOGIN | VARCHAR2(64) | Y | NO | NO | NO | |
| LOGIN_UC | VARCHAR2(64) | Y | NO | NO | NO | |
| PASSWORD | VARCHAR2(38) | Y | NO | NO | NO | |
| OLD_PASSWORD | VARCHAR2(38) | Y | NO | NO | NO | |
| ORACLE_CONTACT_ID | NUMBER(38) | Y | NO | NO | NO | |
| CREATED | DATE | Y | NO | NO | NO | |
| MODIFIED | DATE | Y | NO | NO | NO | |
| IGNORE_FLAG | CHAR(1) | Y | NO | NO | NO | |
Query:
Legend: string keyword reserved word operator
select
wcon.id,
wcon.org_id,
wcon.login,
wcon.login_uc,
wcon.password,
wcon.old_password,
wcon.oracle_contact_id,
wcon.created,
wcon.modified,
wcon.ignore_flag
from
web_contact wcon
minus
select
wcd.id,
wcd.org_id,
wcd.login,
wcd.login_uc,
wcd.password,
wcd.old_password,
wcd.oracle_contact_id,
wcd.created,
wcd.modified,
wcd.ignore_flag
from
rhnWebContactDisabled wcd