|
ACS3 Data Model |
||||||||||||
| |||||||||||||
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|---|---|---|---|---|---|
| ADV_KEY | VARCHAR2(200.0) | N | YES | YES | YES | |
| ENTRY_DATE | DATE | N | YES | YES | YES | |
| DISPLAY_COUNT | NUMBER(38) | Y | YES | YES | YES | |
| CLICK_COUNT | NUMBER(38) | Y | YES | YES | YES |
SELECT "ADV_KEY","ENTRY_DATE","DISPLAY_COUNT","CLICK_COUNT" FROM adv_log WHERE entry_date = TRUNC(sysdate)