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)
public assets (table)
public atinterface (table)
public category_node (table)
public datalinkinterface (table)
public distpoller (table)
public ifservices (table)
public inventory (table)
public ipinterface (table)
public iprouteinterface (table)
public notifications (table)
public outages (table)
public pathoutage (table)
public snmpinterface (table)
public stpinterface (table)
public stpnode (table)
public vlan (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)
public assets (table)
public atinterface (table)
public category_node (table)
public datalinkinterface (table)
public distpoller (table)
public ifservices (table)
public inventory (table)
public ipinterface (table)
public iprouteinterface (table)
public notifications (table)
public outages (table)
public pathoutage (table)
public snmpinterface (table)
public stpinterface (table)
public stpnode (table)
public vlan (table)
»
public node (table)
»
Database Objects Oracle Demo Schema
[X]
»
public node (table)
»
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
.