Index

A

C

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

INCOME_LEVEL 4.5.1
installation
- 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_ID 4.5.3, 4.5.4
ORDER_MODE 4.5.3
ORDER_STATUS 4.5.3
ORDER_TOTAL 4.5.3

P

PHONE_NUMBER 4.3.3
PHONE_NUMBERS 4.5.1
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_ID 4.5.2, 4.7.1, 4.5.4, 4.5.5, 4.5.6
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.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
STREET_ADDRESS 4.3.6
SUPPLIER_ID 4.5.6

T

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.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