Database Objects Oracle Demo Schema

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 AdventureWorks Database Objects OpenNMS Database Objects Oracle Demo Schema SnippetsAndTemplates WikiMarkup WikiMarkup-Pictures WikiMarkup-Tables

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)

Production Product (table)Production ProductListPriceHistory (table)

Sales (schema)Sales Store (table)

devio dbscript ScrewTurn Wiki

Navigation¶

wikibot ¶

Tables ¶

Views ¶

Procedures ¶

Functions ¶

Types ¶

Sequences ¶