RHNWEBCONTACTENABLED
DDL scriptColumns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| ID | NUMBER(38) | N | NO | NO | NO | |
| ORG_ID | NUMBER(38) | N | NO | NO | NO | |
| LOGIN | VARCHAR2(64) | N | NO | NO | NO | |
| LOGIN_UC | VARCHAR2(64) | N | NO | NO | NO | |
| PASSWORD | VARCHAR2(110) | N | NO | NO | NO | |
| ORACLE_CONTACT_ID | NUMBER(38) | Y | NO | NO | NO | |
| CREATED | TIMESTAMP(6) WITH LOCAL TIME ZONE | N | NO | NO | NO | |
| MODIFIED | TIMESTAMP(6) WITH LOCAL TIME ZONE | N | NO | NO | NO | |
| IGNORE_FLAG | CHAR(1) | N | NO | NO | NO | |
| READ_ONLY | CHAR(1) | N | NO | NO | NO | |
Query:
Legend: string keyword reserved word operator
select
wcon.id,
wcon.org_id,
wcon.login,
wcon.login_uc,
wcon.password,
wcon.oracle_contact_id,
wcon.created,
wcon.modified,
wcon.ignore_flag,
wcon.read_only
from
web_contact wcon left join rhnWebContactDisabled wcond on wcond.id = wcon.id
where wcond.id is null