Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Discuss (0)
View Page Code
History
Database Objects Oracle Demo Schema
Print
RSS
Modified on 2011/08/27 12:09
by
wikibot
Categorized as
Uncategorized
HR ADD_JOB_HISTORY (procedure)
HR COUNTRIES (table)
HR DEPARTMENTS (table)
HR DEPARTMENTS_SEQ (sequence)
HR EMP_DETAILS_VIEW (view)
HR EMPLOYEES (table)
HR EMPLOYEES_SEQ (sequence)
HR JOB_HISTORY (table)
HR JOBS (table)
HR LOCATIONS (table)
HR LOCATIONS_SEQ (sequence)
HR REGIONS (table)
HR SECURE_DML (procedure)
IX AQ$_ORDERS_QUEUETABLE_G (table)
IX AQ$_ORDERS_QUEUETABLE_H (table)
IX AQ$_ORDERS_QUEUETABLE_I (table)
IX AQ$_ORDERS_QUEUETABLE_N (sequence)
IX AQ$_ORDERS_QUEUETABLE_S (table)
IX AQ$_ORDERS_QUEUETABLE_T (table)
IX AQ$_STREAMS_QUEUE_TABLE_G (table)
IX AQ$_STREAMS_QUEUE_TABLE_H (table)
IX AQ$_STREAMS_QUEUE_TABLE_I (table)
IX AQ$_STREAMS_QUEUE_TABLE_N (sequence)
IX AQ$_STREAMS_QUEUE_TABLE_S (table)
IX AQ$_STREAMS_QUEUE_TABLE_T (table)
IX AQ$ORDERS_QUEUETABLE (view)
IX AQ$ORDERS_QUEUETABLE_R (view)
IX AQ$ORDERS_QUEUETABLE_S (view)
IX AQ$STREAMS_QUEUE_TABLE (view)
IX AQ$STREAMS_QUEUE_TABLE_R (view)
IX AQ$STREAMS_QUEUE_TABLE_S (view)
IX ORDER_EVENT_TYP (type)
IX ORDERS_QUEUETABLE (table)
IX STREAMS_QUEUE_TABLE (table)
IX SYS_IOT_OVER_49905 (table)
IX SYS_IOT_OVER_49922 (table)
OE ACCOUNT_MANAGERS (view)
OE BOMBAY_INVENTORY (view)
OE CATALOG_TYP (type)
OE CATEGORIES_TAB (table)
OE CATEGORY_TYP (type)
OE COMPOSITE_CATEGORY_TYP (type)
OE CORPORATE_CUSTOMER_TYP (type)
OE CUST_ADDRESS_TYP (type)
OE CUSTOMER_TYP (type)
OE CUSTOMERS (table)
OE CUSTOMERS_VIEW (view)
OE DEPTVIEW (view)
OE GET_PHONE_NUMBER_F (function)
OE INVENTORIES (table)
OE INVENTORY_LIST_TYP (type)
OE INVENTORY_TYP (type)
OE LEAF_CATEGORY_TYP (type)
OE OC_CORPORATE_CUSTOMERS (view)
OE OC_CUSTOMERS (view)
OE OC_INVENTORIES (view)
OE OC_ORDERS (view)
OE OC_PRODUCT_INFORMATION (view)
OE ORDER_ITEM_LIST_TYP (type)
OE ORDER_ITEM_TYP (type)
OE ORDER_ITEMS (table)
OE ORDER_LIST_TYP (type)
OE ORDER_TYP (type)
OE ORDERS (table)
OE ORDERS_SEQ (sequence)
OE ORDERS_VIEW (view)
OE PHONE_LIST_TYP (type)
OE PRODUCT_DESCRIPTIONS (table)
OE PRODUCT_INFORMATION (table)
OE PRODUCT_INFORMATION_TYP (type)
OE PRODUCT_PRICES (view)
OE PRODUCT_REF_LIST_NESTEDTAB (table)
OE PRODUCT_REF_LIST_TYP (type)
OE PRODUCTS (view)
OE PROMOTIONS (table)
OE PURCHASEORDERS (table)
OE STYLESHEET_TAB (table)
OE SUBCATEGORY_REF_LIST_NESTEDTAB (table)
OE SUBCATEGORY_REF_LIST_TYP (type)
OE SYDNEY_INVENTORY (view)
OE SYS_YOID0000050342$ (type)
OE SYS_YOID0000050344$ (type)
OE SYS_YOID0000050346$ (type)
OE SYS_YOID0000050348$ (type)
OE SYS_YOID0000050350$ (type)
OE TORONTO_INVENTORY (view)
OE WAREHOUSE_TYP (type)
OE WAREHOUSES (table)
OE XDBPO_ACTION_COLLECTION (type)
OE XDBPO_ACTION_TYPE (type)
OE XDBPO_ACTIONS_TYPE (type)
OE XDBPO_LINEITEM_COLLECTION (type)
OE XDBPO_LINEITEM_TYPE (type)
OE XDBPO_LINEITEMS_TYPE (type)
OE XDBPO_PART_TYPE (type)
OE XDBPO_REJECTION_TYPE (type)
OE XDBPO_SHIPINSTRUCTIONS_TYPE (type)
OE XDBPO_TYPE (type)
PM ADHEADER_TYP (type)
PM ONLINE_MEDIA (table)
PM PRINT_MEDIA (table)
PM TEXTDOC_TAB (type)
PM TEXTDOC_TYP (type)
PM TEXTDOCS_NESTEDTAB (table)
SH CAL_MONTH_SALES_MV (table)
SH CHANNELS (table)
SH COSTS (table)
SH COUNTRIES (table)
SH CUSTOMERS (table)
SH DR$SUP_TEXT_IDX$I (table)
SH DR$SUP_TEXT_IDX$K (table)
SH DR$SUP_TEXT_IDX$N (table)
SH DR$SUP_TEXT_IDX$R (table)
SH FWEEK_PSCAT_SALES_MV (table)
SH MVIEW$_EXCEPTIONS (table)
SH PRODUCTS (table)
SH PROFITS (view)
SH PROMOTIONS (table)
SH SALES (table)
SH SALES_TRANSACTIONS_EXT (table)
SH SUPPLEMENTARY_DEMOGRAPHICS (table)
SH TIMES (table)
HR ADD_JOB_HISTORY (procedure)
HR COUNTRIES (table)
HR DEPARTMENTS (table)
HR DEPARTMENTS_SEQ (sequence)
HR EMP_DETAILS_VIEW (view)
HR EMPLOYEES (table)
HR EMPLOYEES_SEQ (sequence)
HR JOB_HISTORY (table)
HR JOBS (table)
HR LOCATIONS (table)
HR LOCATIONS_SEQ (sequence)
HR REGIONS (table)
HR SECURE_DML (procedure)
IX AQ$_ORDERS_QUEUETABLE_G (table)
IX AQ$_ORDERS_QUEUETABLE_H (table)
IX AQ$_ORDERS_QUEUETABLE_I (table)
IX AQ$_ORDERS_QUEUETABLE_N (sequence)
IX AQ$_ORDERS_QUEUETABLE_S (table)
IX AQ$_ORDERS_QUEUETABLE_T (table)
IX AQ$_STREAMS_QUEUE_TABLE_G (table)
IX AQ$_STREAMS_QUEUE_TABLE_H (table)
IX AQ$_STREAMS_QUEUE_TABLE_I (table)
IX AQ$_STREAMS_QUEUE_TABLE_N (sequence)
IX AQ$_STREAMS_QUEUE_TABLE_S (table)
IX AQ$_STREAMS_QUEUE_TABLE_T (table)
IX AQ$ORDERS_QUEUETABLE (view)
IX AQ$ORDERS_QUEUETABLE_R (view)
IX AQ$ORDERS_QUEUETABLE_S (view)
IX AQ$STREAMS_QUEUE_TABLE (view)
IX AQ$STREAMS_QUEUE_TABLE_R (view)
IX AQ$STREAMS_QUEUE_TABLE_S (view)
IX ORDER_EVENT_TYP (type)
IX ORDERS_QUEUETABLE (table)
IX STREAMS_QUEUE_TABLE (table)
IX SYS_IOT_OVER_49905 (table)
IX SYS_IOT_OVER_49922 (table)
OE ACCOUNT_MANAGERS (view)
OE BOMBAY_INVENTORY (view)
OE CATALOG_TYP (type)
OE CATEGORIES_TAB (table)
OE CATEGORY_TYP (type)
OE COMPOSITE_CATEGORY_TYP (type)
OE CORPORATE_CUSTOMER_TYP (type)
OE CUST_ADDRESS_TYP (type)
OE CUSTOMER_TYP (type)
OE CUSTOMERS (table)
OE CUSTOMERS_VIEW (view)
OE DEPTVIEW (view)
OE GET_PHONE_NUMBER_F (function)
OE INVENTORIES (table)
OE INVENTORY_LIST_TYP (type)
OE INVENTORY_TYP (type)
OE LEAF_CATEGORY_TYP (type)
OE OC_CORPORATE_CUSTOMERS (view)
OE OC_CUSTOMERS (view)
OE OC_INVENTORIES (view)
OE OC_ORDERS (view)
OE OC_PRODUCT_INFORMATION (view)
OE ORDER_ITEM_LIST_TYP (type)
OE ORDER_ITEM_TYP (type)
OE ORDER_ITEMS (table)
OE ORDER_LIST_TYP (type)
OE ORDER_TYP (type)
OE ORDERS (table)
OE ORDERS_SEQ (sequence)
OE ORDERS_VIEW (view)
OE PHONE_LIST_TYP (type)
OE PRODUCT_DESCRIPTIONS (table)
OE PRODUCT_INFORMATION (table)
OE PRODUCT_INFORMATION_TYP (type)
OE PRODUCT_PRICES (view)
OE PRODUCT_REF_LIST_NESTEDTAB (table)
OE PRODUCT_REF_LIST_TYP (type)
OE PRODUCTS (view)
OE PROMOTIONS (table)
OE PURCHASEORDERS (table)
OE STYLESHEET_TAB (table)
OE SUBCATEGORY_REF_LIST_NESTEDTAB (table)
OE SUBCATEGORY_REF_LIST_TYP (type)
OE SYDNEY_INVENTORY (view)
OE SYS_YOID0000050342$ (type)
OE SYS_YOID0000050344$ (type)
OE SYS_YOID0000050346$ (type)
OE SYS_YOID0000050348$ (type)
OE SYS_YOID0000050350$ (type)
OE TORONTO_INVENTORY (view)
OE WAREHOUSE_TYP (type)
OE WAREHOUSES (table)
OE XDBPO_ACTION_COLLECTION (type)
OE XDBPO_ACTION_TYPE (type)
OE XDBPO_ACTIONS_TYPE (type)
OE XDBPO_LINEITEM_COLLECTION (type)
OE XDBPO_LINEITEM_TYPE (type)
OE XDBPO_LINEITEMS_TYPE (type)
OE XDBPO_PART_TYPE (type)
OE XDBPO_REJECTION_TYPE (type)
OE XDBPO_SHIPINSTRUCTIONS_TYPE (type)
OE XDBPO_TYPE (type)
PM ADHEADER_TYP (type)
PM ONLINE_MEDIA (table)
PM PRINT_MEDIA (table)
PM TEXTDOC_TAB (type)
PM TEXTDOC_TYP (type)
PM TEXTDOCS_NESTEDTAB (table)
SH CAL_MONTH_SALES_MV (table)
SH CHANNELS (table)
SH COSTS (table)
SH COUNTRIES (table)
SH CUSTOMERS (table)
SH DR$SUP_TEXT_IDX$I (table)
SH DR$SUP_TEXT_IDX$K (table)
SH DR$SUP_TEXT_IDX$N (table)
SH DR$SUP_TEXT_IDX$R (table)
SH FWEEK_PSCAT_SALES_MV (table)
SH MVIEW$_EXCEPTIONS (table)
SH PRODUCTS (table)
SH PROFITS (view)
SH PROMOTIONS (table)
SH SALES (table)
SH SALES_TRANSACTIONS_EXT (table)
SH SUPPLEMENTARY_DEMOGRAPHICS (table)
SH TIMES (table)
»
Database Objects Oracle Demo Schema
[X]
»
Database Objects Oracle Demo Schema
wikibot
¶
Oracle Demo Schema (test 104 17.02.2011 23:58:21)
Tables
¶
AQ$_ORDERS_QUEUETABLE_G (IX)
AQ$_ORDERS_QUEUETABLE_H (IX)
AQ$_ORDERS_QUEUETABLE_I (IX)
AQ$_ORDERS_QUEUETABLE_S (IX)
AQ$_ORDERS_QUEUETABLE_T (IX)
AQ$_STREAMS_QUEUE_TABLE_G (IX)
AQ$_STREAMS_QUEUE_TABLE_H (IX)
AQ$_STREAMS_QUEUE_TABLE_I (IX)
AQ$_STREAMS_QUEUE_TABLE_S (IX)
AQ$_STREAMS_QUEUE_TABLE_T (IX)
CAL_MONTH_SALES_MV (SH)
CATEGORIES_TAB (OE)
CHANNELS (SH)
COSTS (SH)
COUNTRIES (HR)
COUNTRIES (SH)
CUSTOMERS (OE)
CUSTOMERS (SH)
DEPARTMENTS (HR)
DR$SUP_TEXT_IDX$I (SH)
DR$SUP_TEXT_IDX$K (SH)
DR$SUP_TEXT_IDX$N (SH)
DR$SUP_TEXT_IDX$R (SH)
EMPLOYEES (HR)
FWEEK_PSCAT_SALES_MV (SH)
INVENTORIES (OE)
JOB_HISTORY (HR)
JOBS (HR)
LOCATIONS (HR)
MVIEW$_EXCEPTIONS (SH)
ONLINE_MEDIA (PM)
ORDER_ITEMS (OE)
ORDERS (OE)
ORDERS_QUEUETABLE (IX)
PRINT_MEDIA (PM)
PRODUCT_DESCRIPTIONS (OE)
PRODUCT_INFORMATION (OE)
PRODUCT_REF_LIST_NESTEDTAB (OE)
PRODUCTS (SH)
PROMOTIONS (OE)
PROMOTIONS (SH)
PURCHASEORDERS (OE)
REGIONS (HR)
SALES (SH)
SALES_TRANSACTIONS_EXT (SH)
STREAMS_QUEUE_TABLE (IX)
STYLESHEET_TAB (OE)
SUBCATEGORY_REF_LIST_NESTEDTAB (OE)
SUPPLEMENTARY_DEMOGRAPHICS (SH)
SYS_IOT_OVER_49905 (IX)
SYS_IOT_OVER_49922 (IX)
TEXTDOCS_NESTEDTAB (PM)
TIMES (SH)
WAREHOUSES (OE)
Views
¶
ACCOUNT_MANAGERS (OE)
AQ$ORDERS_QUEUETABLE (IX)
AQ$ORDERS_QUEUETABLE_R (IX)
AQ$ORDERS_QUEUETABLE_S (IX)
AQ$STREAMS_QUEUE_TABLE (IX)
AQ$STREAMS_QUEUE_TABLE_R (IX)
AQ$STREAMS_QUEUE_TABLE_S (IX)
BOMBAY_INVENTORY (OE)
CUSTOMERS_VIEW (OE)
DEPTVIEW (OE)
EMP_DETAILS_VIEW (HR)
OC_CORPORATE_CUSTOMERS (OE)
OC_CUSTOMERS (OE)
OC_INVENTORIES (OE)
OC_ORDERS (OE)
OC_PRODUCT_INFORMATION (OE)
ORDERS_VIEW (OE)
PRODUCT_PRICES (OE)
PRODUCTS (OE)
PROFITS (SH)
SYDNEY_INVENTORY (OE)
TORONTO_INVENTORY (OE)
Procedures
¶
ADD_JOB_HISTORY (HR)
SECURE_DML (HR)
Functions
¶
GET_PHONE_NUMBER_F (OE)
Types
¶
ADHEADER_TYP (PM)
CATALOG_TYP (OE)
CATEGORY_TYP (OE)
COMPOSITE_CATEGORY_TYP (OE)
CORPORATE_CUSTOMER_TYP (OE)
CUST_ADDRESS_TYP (OE)
CUSTOMER_TYP (OE)
INVENTORY_LIST_TYP (OE)
INVENTORY_TYP (OE)
LEAF_CATEGORY_TYP (OE)
ORDER_EVENT_TYP (IX)
ORDER_ITEM_LIST_TYP (OE)
ORDER_ITEM_TYP (OE)
ORDER_LIST_TYP (OE)
ORDER_TYP (OE)
PHONE_LIST_TYP (OE)
PRODUCT_INFORMATION_TYP (OE)
PRODUCT_REF_LIST_TYP (OE)
SUBCATEGORY_REF_LIST_TYP (OE)
SYS_YOID0000050342$ (OE)
SYS_YOID0000050344$ (OE)
SYS_YOID0000050346$ (OE)
SYS_YOID0000050348$ (OE)
SYS_YOID0000050350$ (OE)
TEXTDOC_TAB (PM)
TEXTDOC_TYP (PM)
WAREHOUSE_TYP (OE)
XDBPO_ACTION_COLLECTION (OE)
XDBPO_ACTION_TYPE (OE)
XDBPO_ACTIONS_TYPE (OE)
XDBPO_LINEITEM_COLLECTION (OE)
XDBPO_LINEITEM_TYPE (OE)
XDBPO_LINEITEMS_TYPE (OE)
XDBPO_PART_TYPE (OE)
XDBPO_REJECTION_TYPE (OE)
XDBPO_SHIPINSTRUCTIONS_TYPE (OE)
XDBPO_TYPE (OE)
Sequences
¶
AQ$_ORDERS_QUEUETABLE_N (IX)
AQ$_STREAMS_QUEUE_TABLE_N (IX)
DEPARTMENTS_SEQ (HR)
EMPLOYEES_SEQ (HR)
LOCATIONS_SEQ (HR)
ORDERS_SEQ (OE)
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.