Index

A

C

CALENBDAR_QUARTER_ID 4.11.8
CALENDAR_MONTH_DESC 4.11.8
CALENDAR_MONTH_ID 4.11.8
CALENDAR_MONTH_NAME 4.11.8
CALENDAR_MONTH_NUMBER 4.11.8
CALENDAR_QUARTER_DESC 4.11.8
CALENDAR_QUARTER_NUMBER 4.11.8
CALENDAR_WEEK_NUMBER 4.11.8
CALENDAR_YEAR 4.11.8
CALENDAR_YEAR_ID 4.11.8
CATALOG_URL 4.5.6
CATEGORY_ID 4.5.6
CHAIN_NO 4.9.1, 4.9.2
CHANNEL_CLASS 4.11.1
CHANNEL_CLASS_ID 4.11.1
CHANNEL_DESC 4.11.1
CHANNEL_ID 4.11.1, 4.11.2, 4.11.7
CHANNEL_TOTAL 4.11.1
CHANNEL_TOTAL_ID 4.11.1
CITY 4.3.6
COMMISSION_PCT 4.3.3
CORRID 4.9.1, 4.9.2
CO schema 1.4.7
- objects 4.12
- scripts 4.12
COUNTRY_ID 4.3.1, 4.11.3, 4.3.6, 4.11.4
COUNTRY_ISO_CODE 4.11.3
COUNTRY_NAME 4.3.1, 4.11.3
COUNTRY_NAME_HIST 4.11.3
COUNTRY_REGION 4.11.3
COUNTRY_REGION_ID 4.11.3
COUNTRY_SUBREGION 4.11.3
COUNTRY_SUBREGION_ID 4.11.3
COUNTRY_TOTAL 4.11.3
COUNTRY_TOTAL_ID 4.11.3
CREDIT_LIMIT 4.5.1
CSCN 4.9.1, 4.9.2
CUST_ADDRESS 4.5.1
CUST_CITY 4.11.4
CUST_CITY_ID 4.11.4
CUST_CREDIT_LIMIT 4.11.4
CUST_EFF_FROM 4.11.4
CUST_EFF_TO 4.11.4
CUST_EMAIL 4.5.1, 4.11.4
CUST_FIRST_NAME 4.5.1, 4.11.4
CUST_GENDER 4.11.4
CUST_GEO_LOCATION 4.5.1
CUST_ID 4.11.4, 4.11.7
CUST_INCOME_LEVEL 4.11.4
CUST_LAST_NAME 4.5.1, 4.11.4
CUST_MAIN_PHONE_NUMBER 4.11.4
CUST_MARITAL_STATUS 4.11.4
CUST_POSTAL_CODE 4.11.4
CUST_SRC_ID 4.11.4
CUST_STATE_PROVINCE 4.11.4
CUST_STATE_PROVINCE_ID 4.11.4
CUST_STREET_ADDRESS 4.11.4
CUST_TOTAL 4.11.4
CUST_TOTAL_ID 4.11.4
CUST_VALID 4.11.4
CUST_YEAR_OF_BIRTH 4.11.4
customer_id 4.13.1, 4.13.4
CUSTOMER_ID 4.5.1, 4.5.3

D

Database Configuration Assistant
- using to install Sample Schemas 2.1.1
DATE_OF_BIRTH 4.5.1
DAY_NAME 4.11.8
DAY_NUMBER_IN_MONTH 4.11.8
DAY_NUMBER_IN_WEEK 4.11.8
DAYS_IN_CAL_MONTH 4.11.8
DAYS_IN_CAL_QUARTER 4.11.8
DAYS_IN_CAL_YEAR 4.11.8
DAYS_IN_FIS_MONTH 4.11.8
DAYS_IN_FIS_QUARTER 4.11.8
DAYS_IN_FIS_YEAR 4.11.8
DELAY 4.9.1, 4.9.2
DEPARTMENT_ID 4.3.2, 4.3.3, 4.3.5
DEPARTMENT_NAME 4.3.2
DEPT table 1
DEQ_TID 4.9.1, 4.9.2
DEQ_TIME 4.9.1, 4.9.2
DEQUEUE_MSGID 4.9.1, 4.9.2
DSCN 4.9.1, 4.9.2

E

F

G

GENDER 4.5.1

H

HIRE_DATE 4.3.3
HR.COUNTRIES 4.3.1
HR.DEPARTMENTS 4.3.2
HR.EMPLOYEES 4.3.3
HR.JOB_HISTORY 4.3.5
HR.JOBS 4.3.4
HR.LOCATIONS 4.3.6
HR.REGIONS 4.3.7
HR schema
- general description 1.4.1
- installing 2.1.2

I

image_charset 4.13.3
image_filename 4.13.3
image_last_updated 4.13.3
image_mime_type 4.13.3
INCOME_LEVEL 4.5.1
installation
- CO schema 2.3
- github 2.3
- GitHub 2.2
- manual, of Sample Schemas 2.2
- using Database Configuration Assistant 2.1.1
installing sample schema 2.1
installing Sample Schemas 2
Installing Sample Schemas 2.1
IX.ORDERS_QUEUETABLE 4.9.1
IX.STREAMS_QUEUE_TABLE 4.9.2
IX schema
- general description 1.4.5
- scripts 4.8

J

JOB_ID 4.3.3, 4.3.4, 4.3.5
JOB_TITLE 4.3.4

L

M

N

NLS_LANGUAGE 4.5.1
NLS_TERRITORY 4.5.1

O

OC subschema
- general description 1.4.3
OE.CUSTOMERS 4.5.1
OE.INVENTORIES 4.5.2
OE.ORDER_ITEMS 4.5.4
OE.PRODUCT_DESCRIPTIONS 4.5.5
OE.PRODUCT_INFORMATION 4.5.6
OE.WAREHOUSES 4.5.7
OE schema
- general description 1.4.2
- scripts 4.4
ORDER_DATE 4.5.3
order_datetime 4.13.4
order_id 4.13.4, 4.13.5
ORDER_ID 4.5.3, 4.5.4
ORDER_MODE 4.5.3
order_status 4.13.4
ORDER_STATUS 4.5.3
ORDER_TOTAL 4.5.3

P

PHONE_NUMBER 4.3.3
PHONE_NUMBERS 4.5.1
physical_address 4.13.2
PM.PRINT_MEDIA 4.7.1
PM schema
- general description 1.4.4
- scripts 4.6
POSTAL_CODE 4.3.6
PRD_CATEGORY_ID 4.11.5
PRD_EFF_FROM 4.11.5
PRD_MIN_PRICE 4.11.5
PRD_PACK_SIZE 4.11.5
PRIORITY 4.9.1, 4.9.2
PRMO_CATEGORY_ID 4.11.6
PROD_CATEGORY 4.11.5
PROD_CATEGORY_DESC 4.11.5
PROD_DESC 4.11.5
PROD_EFF_TO 4.11.5
PROD_ID 4.11.2, 4.11.7, 4.11.5
PROD_LIST_PRICE 4.11.5
PROD_NAME 4.11.5
PROD_SRC_ID 4.11.5
PROD_STATUS 4.11.5
PROD_SUBCATEGORY 4.11.5
PROD_SUBCATEGORY_DESC 4.11.5
PROD_SUBCATEGORY_ID 4.11.5
PROD_SUPPLIER_ID 4.11.5
PROD_TOTAL 4.11.5
PROD_TOTAL_ID 4.11.5
PROD_UNIT_OF_MEASURE 4.11.5
PROD_VALID 4.11.5
PROD_WEIGHT_CLASS 4.11.5
PRODUCT_DESCRIPTION 4.5.6
product_details 4.13.3
product_id 4.13.3, 4.13.5
PRODUCT_ID 4.5.2, 4.7.1, 4.5.4, 4.5.5, 4.5.6
product_image 4.13.3
product_name 4.13.3
PRODUCT_NAME 4.5.6
PRODUCT_STATUS 4.5.6
PROMO_BEGIN_DATE 4.11.6
PROMO_CATEGORY 4.11.6
PROMO_COST 4.11.6
PROMO_END_DATE 4.11.6
PROMO_ID 4.11.2, 4.11.6, 4.11.7
PROMO_NAME 4.11.6
PROMO_SUBCATEGORY 4.11.6
PROMO_SUBCATEGORY_ID 4.11.6
PROMO_TOTAL 4.11.6
PROMO_TOTAL_ID 4.11.6
PROMOTION_ID 4.5.3

Q

Q_NAME 4.9.1, 4.9.2
quantity 4.13.5
QUANTITY 4.5.4
QUANTITY_ON_HAND 4.5.2
QUANTITY_SOLD 4.11.7

R

RECIPIENT_KEY 4.9.1, 4.9.2
REGION_ID 4.3.1, 4.3.7
REGION_NAME 4.3.7
resetting the Sample Schemas 2.2.1
RETRY_COUNT 4.9.1, 4.9.2

S

SALARY 4.3.3
SALES_REP_ID 4.5.3
sample schema 2.1
Sample Schema
- scripts
  - OE 4.4
  - PM 4.6
- scripts, general information 4
Sample Schemas
- design principles 1.2
- general information 1.1
- installing 2
- scripts
  - master 4.1
SCOTT schema 1
SENDER_ADDRESS 4.9.1, 4.9.2
SENDER_NAME 4.9.1, 4.9.2
SENDER_PROTOCOL 4.9.1, 4.9.2
SH.CHANNELS 4.11.1
SH.COSTS 4.11.2
SH.COUNTRIES 4.11.3
SH.CUSTOMERS 4.11.4
SH.PRODUCTS 4.11.5
SH.SALES 4.11.7
SH.TIMES 4.11.8
SH schema
- general description 1.4.6
- scripts 4.10
START_DATE 4.3.5
STATE 4.9.1, 4.9.2
STATE_PROVINCE 4.3.6
STEP_NO 4.9.1, 4.9.2
store_id 4.13.2, 4.13.4
store_name 4.13.2
STREET_ADDRESS 4.3.6
SUPPLIER_ID 4.5.6

T

table
- description 4.13.1, 4.13.2, 4.13.3, 4.13.4, 4.13.5
TIME_DESC 4.11.2
TIME_ID 4.11.7, 4.11.8
TIME_MANAGER_INFO 4.9.1, 4.9.2
TRANSLATED_DESCRIPTION 4.5.5
TRANSLATED_NAME 4.5.5

U

UNIT_COST 4.11.2
unit_price 4.13.3, 4.13.5
UNIT_PRICE 4.5.4, 4.11.2
USER_DATA 4.9.1, 4.9.2
USER_PROP 4.9.1, 4.9.2

A

C

D

E

F

G

H

I

J

L

M

N

O

P

Q

R

S

T

U

W