Go to main content
19/19
Index
A
C
D
E
F
G
H
I
J
L
M
N
O
P
Q
R
S
T
U
W
A
ACCOUNT_MGR_ID
1
AD_COMPOSITE
1
AD_FINALTEXT
1
AD_FLTEXTN
1
AD_GRAPHIC
1
AD_HEADER
1
AD_ID
1
AD_PHOTO
1
AD_SOURCETEXT
1
AD_TEXTDOCS_NTAB
1
AMOUNT_SOLD
1
C
CALENBDAR_QUARTER_ID
1
CALENDAR_MONTH_DESC
1
CALENDAR_MONTH_ID
1
CALENDAR_MONTH_NAME
1
CALENDAR_MONTH_NUMBER
1
CALENDAR_QUARTER_DESC
1
CALENDAR_QUARTER_NUMBER
1
CALENDAR_WEEK_NUMBER
1
CALENDAR_YEAR
1
CALENDAR_YEAR_ID
1
CATALOG_URL
1
CATEGORY_ID
1
CHAIN_NO
1
,
2
CHANNEL_CLASS
1
CHANNEL_CLASS_ID
1
CHANNEL_DESC
1
CHANNEL_ID
1
,
2
,
3
CHANNEL_TOTAL
1
CHANNEL_TOTAL_ID
1
CITY
1
COMMISSION_PCT
1
CORRID
1
,
2
COUNTRY_ID
1
,
2
,
3
COUNTRY_ISO_CODE
1
COUNTRY_NAME
1
,
2
COUNTRY_NAME_HIST
1
COUNTRY_REGION
1
COUNTRY_REGION_ID
1
COUNTRY_SUBREGION
1
COUNTRY_SUBREGION_ID
1
COUNTRY_TOTAL
1
COUNTRY_TOTAL_ID
1
CREDIT_LIMIT
1
CSCN
1
,
2
CUST_ADDRESS
1
CUST_CITY
1
CUST_CITY_ID
1
CUST_CREDIT_LIMIT
1
CUST_EFF_FROM
1
CUST_EFF_TO
1
CUST_EMAIL
1
,
2
CUST_FIRST_NAME
1
,
2
CUST_GENDER
1
CUST_GEO_LOCATION
1
CUST_ID
1
,
2
CUST_INCOME_LEVEL
1
CUST_LAST_NAME
1
,
2
CUST_MAIN_PHONE_NUMBER
1
CUST_MARITAL_STATUS
1
CUST_POSTAL_CODE
1
CUST_SRC_ID
1
CUST_STATE_PROVINCE
1
CUST_STATE_PROVINCE_ID
1
CUST_STREET_ADDRESS
1
CUST_TOTAL
1
CUST_TOTAL_ID
1
CUST_VALID
1
CUST_YEAR_OF_BIRTH
1
CUSTOMER_ID
1
,
2
D
Database Configuration Assistant
using to install Sample Schemas
1
DATE_OF_BIRTH
1
DAY_NAME
1
DAY_NUMBER_IN_MONTH
1
DAY_NUMBER_IN_WEEK
1
DAYS_IN_CAL_MONTH
1
DAYS_IN_CAL_QUARTER
1
DAYS_IN_CAL_YEAR
1
DAYS_IN_FIS_MONTH
1
DAYS_IN_FIS_QUARTER
1
DAYS_IN_FIS_YEAR
1
DELAY
1
,
2
DEPARTMENT_ID
1
,
2
,
3
DEPARTMENT_NAME
1
DEPT table
1
DEQ_TID
1
,
2
DEQ_TIME
1
,
2
DEQUEUE_MSGID
1
,
2
DSCN
1
,
2
E
EEQ_UID
1
,
2
EMAIL
1
EMPLOYEE_ID
1
,
2
EMP table
1
END_DATE
1
END_OF_CAL_MONTH
1
END_OF_CAL_QUARTER
1
END_OF_CAL_YEAR
1
END_OF_FIS_MONTH
1
END_OF_FIS_QUARTER
1
END_OF_FIS_YEAR
1
ENQ_TID
1
,
2
ENQ_TIME
1
,
2
ENQ_UID
1
,
2
EO.ORDERS
1
EXCEPTION_QSCHEMA
1
,
2
EXCEPTION_QUEUE
1
,
2
EXPIRATION
1
,
2
F
FIRST_NAME
1
FISCAL_MONTH_DESC
1
FISCAL_MONTH_ID
1
FISCAL_MONTH_NAME
1
FISCAL_MONTH_NUMBER
1
FISCAL_QUARTER_DESC
1
FISCAL_QUARTER_ID
1
FISCAL_QUARTER_NUMBER
1
FISCAL_WEEK_NUMBER
1
FISCAL_YEAR
1
FISCAL_YEAR_ID
1
G
GENDER
1
H
HIRE_DATE
1
HR.COUNTRIES
1
HR.DEPARTMENTS
1
HR.EMPLOYEES
1
HR.JOB_HISTORY
1
HR.JOBS
1
HR.LOCATIONS
1
HR.REGIONS
1
HR schema
general description
1
installing
1
I
INCOME_LEVEL
1
installation
GitHub
1
manual, of Sample Schemas
1
using Database Configuration Assistant
1
installing sample schema
1
installing Sample Schemas
1
Installing Sample Schemas
1
IX.ORDERS_QUEUETABLE
1
IX.STREAMS_QUEUE_TABLE
1
IX schema
general description
1
scripts
1
J
JOB_ID
1
,
2
,
3
JOB_TITLE
1
L
LANGUAGE_ID
1
LAST_NAME
1
LINE_ITEM_ID
1
LIST_PRICE
1
LOCAL_ORDER_NO
1
,
2
LOCATION_ID
1
,
2
,
3
M
MANAGER_ID
1
,
2
MARITAL_STATUS
1
MAX_SALARY
1
MIN_PRICE
1
MIN_SALARY
1
MSGID
1
,
2
N
NLS_LANGUAGE
1
NLS_TERRITORY
1
O
OC subschema
general description
1
OE.CUSTOMERS
1
OE.INVENTORIES
1
OE.ORDER_ITEMS
1
OE.PRODUCT_DESCRIPTIONS
1
OE.PRODUCT_INFORMATION
1
OE.WAREHOUSES
1
OE schema
general description
1
scripts
1
ORDER_DATE
1
ORDER_ID
1
,
2
ORDER_MODE
1
ORDER_STATUS
1
ORDER_TOTAL
1
P
PHONE_NUMBER
1
PHONE_NUMBERS
1
PM.ONLINE_MEDIA
1
PM.PRINT_MEDIA
1
PM schema
general description
1
scripts
1
POSTAL_CODE
1
PRD_CATEGORY_ID
1
PRD_EFF_FROM
1
PRD_MIN_PRICE
1
PRD_PACK_SIZE
1
PRIORITY
1
,
2
PRMO_CATEGORY_ID
1
PROD_CATEGORY
1
PROD_CATEGORY_DESC
1
PROD_DESC
1
PROD_EFF_TO
1
PROD_ID
1
,
2
PROD_LIST_PRICE
1
PROD_NAME
1
PROD_SRC_ID
1
PROD_STATUS
1
PROD_SUBCATEGORY
1
PROD_SUBCATEGORY_DESC
1
PROD_SUBCATEGORY_ID
1
PROD_SUPPLIER_ID
1
PROD_TOTAL
1
PROD_TOTAL_ID
1
PROD_UNIT_OF_MEASURE
1
PROD_VALID
1
PROD_WEIGHT_CLASS
1
PRODUCT_AUDIO
1
PRODUCT_DESCRIPTION
1
PRODUCT_ID
1
,
2
,
3
,
4
,
5
PRODUCT_NAME
1
PRODUCT_PHOTO
1
PRODUCT_PHOTO_SIGNATURE
1
PRODUCT_STATUS
1
PRODUCT_TESTIMONIALS
1
PRODUCT_TEXT
1
PRODUCT_THUMBNAIL
1
PRODUCT_VIDEO
1
PROMO_BEGIN_DATE
1
PROMO_CATEGORY
1
PROMO_COST
1
PROMO_END_DATE
1
PROMO_ID
1
,
2
,
3
PROMO_NAME
1
PROMO_SUBCATEGORY
1
PROMO_SUBCATEGORY_ID
1
PROMO_TOTAL
1
PROMO_TOTAL_ID
1
PROMOTION_ID
1
Q
Q_NAME
1
,
2
QUANTITY
1
QUANTITY_ON_HAND
1
QUANTITY_SOLD
1
R
RECIPIENT_KEY
1
,
2
REGION_ID
1
,
2
REGION_NAME
1
resetting the Sample Schemas
1
RETRY_COUNT
1
,
2
S
SALARY
1
SALES_REP_ID
1
sample schema
1
Sample Schema
scripts
OE
1
PM
1
scripts, general information
1
Sample Schemas
design principles
1
general information
1
installing
1
scripts
master
1
SCOTT schema
1
SENDER_ADDRESS
1
,
2
SENDER_NAME
1
,
2
SENDER_PROTOCOL
1
,
2
SH.CHANNELS
1
SH.COSTS
1
SH.COUNTRIES
1
SH.CUSTOMERS
1
SH.PRODUCTS
1
SH.SALES
1
SH.TIMES
1
SH schema
general description
1
scripts
1
START_DATE
1
STATE
1
,
2
STATE_PROVINCE
1
STEP_NO
1
,
2
STREET_ADDRESS
1
SUPPLIER_ID
1
T
TIME_DESC
1
TIME_ID
1
,
2
TIME_MANAGER_INFO
1
,
2
TRANSLATED_DESCRIPTION
1
TRANSLATED_NAME
1
U
UNIT_COST
1
UNIT_PRICE
1
,
2
USER_DATA
1
,
2
USER_PROP
1
,
2
W
WAREHOUSE__NAME
1
WAREHOUSE_ID
1
,
2
WAREHOUSE_SPEC
1
WARRANTY_PERIOD
1
WEEK_ENDING_DAY
1
WEEK_ENDING_DAY_ID
1
WEIGHT_CLASS
1
WH_GEO_LOCATION
1
Scripting on this page enhances content navigation, but does not change the content in any way.