Search Engine

Here you can search through the pages of this Namespace, their attachments and the files uploaded to the system.
Note: the results will only display the items you have permissions to read.

At least one word All words Exact phrase

Search in all Namespaces and all Categories
Search Files and Attachments

Filter by Category

Uncategorized Pages

This search, performed through 2.14 MB (338 documents, 3448 words), completed in 0.1 seconds and yielded 30 results.

Database Objects Oracle Demo Schema — 21.0%

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 ORDERS_VIEW (view) — 2.6%

wikibot View OE.ORDERS_VIEW Source CREATE OR REPLACE VIEW OE.ORDERS_VIEW AS SELECT order_id, TO_DATE(TO_CHAR(order_date,'DD-MON-YY [...]

OE ORDERS (table) — 2.6%

wikibot Table OE.ORDERS Description Contains orders entered by a salesperson as well as over the Web. Columns Column Data Type Nullable Default Description ORDER_ID NUMBER(12, 0) not null PRIMARY KEY column. ORDER_DATE TIMESTAMP(6) WITH LOCAL TIME ZONE not null TIMESTAMP WITH LOCAL TIME ZONE column, NOT NULL constraint. ORDER_MODE VARCHAR2(8) null CHECK constraint. CUSTOMER_ID NUMBER(6, 0) not null ORDER_STATUS NUMBER(2, 0) null 0: Not fully entered, 1: Entered, 2: Canceled - [...]

OE OC_ORDERS (view) — 2.6%

wikibot View OE.OC_ORDERS Source CREATE OR REPLACE VIEW OE.OC_ORDERS AS SELECT o.order_id, o.order_mode,MAKE_REF(oc_customers,o.customer_id), o.order_status,o.order_total,o.sales_rep_id, CAST(MULTISET(SELECT l.order_id,l.line_item_id,l.unit_price,l.quantity, make_ref(oc_product_information,l.product_id) [...]

OE ORDERS_SEQ (sequence) — 2.3%

wikibot Sequence OE.ORDERS_SEQ Sequence Start Value Max. Value [...]

OE ORDER_ITEMS (table) — 2.0%

wikibot Table OE.ORDER_ITEMS Description Example of many-to-many resolution. Columns Column Data Type Nullable Default Description ORDER_ID NUMBER(12, 0) not null Part of concatenated primary key, references orders.order_id. LINE_ITEM_ID NUMBER(3, 0) not null Part of concatenated primary key. PRODUCT_ID NUMBER(6, 0) not null References product_information.product_id. UNIT_PRICE NUMBER(8, 2) null QUANTITY NUMBER(8, 0) null Primary Key Primary Key Columns ORDER_ITEMS_PK ORDER_ID, LINE_ITEM_ID Indexes [...]

OE CUSTOMERS (table) — 2.0%

wikibot Table OE.CUSTOMERS Description Contains customers data either entered by an employee or by the customer Columns Column Data Type Nullable Default Description CUSTOMER_ID NUMBER(6, 0) not null Primary key column. CUST_FIRST_NAME VARCHAR2(20) not null NOT NULL constraint. CUST_LAST_NAME VARCHAR2(20) not null NOT NULL constraint. CUST_ADDRESS OE.CUST_ADDRESS_TYP null Object column of type address_typ. PHONE_NUMBERS OE.PHONE_LIST_TYP null Varray column of type phone_list_typ [...]

OE PRODUCT_INFORMATION (table) — 1.7%

wikibot Table OE.PRODUCT_INFORMATION Description Non-industry-specific data in various categories. Columns Column Data Type Nullable Default Description PRODUCT_ID NUMBER(6, 0) not null Primary key column. PRODUCT_NAME VARCHAR2(50) null PRODUCT_DESCRIPTION VARCHAR2(2000) null Primary language description corresponding to translated_description in CATEGORY_ID NUMBER(2, 0) null Low cardinality column, can be used for bitmap index. WEIGHT_CLASS NUMBER(1, 0) null Low cardinality column, can be used for bitmap index. WARRANTY_PERIOD INTERVAL [...]

OE OC_CUSTOMERS (view) — 1.4%

wikibot View OE.OC_CUSTOMERS Source CREATE OR REPLACE VIEW OE.OC_CUSTOMERS AS SELECT c.customer_id, c.cust_first_name, c.cust_last_name, c.cust_address, c.phone_numbers,c.nls_language,c.nls_territory,c.credit_limit, c.cust_email, CAST(MULTISET(SELECT o.order_id, o.order_mode, MAKE_REF(oc_customers,o.customer_id), o.order_status, o.order_total,o.sales_rep_id, CAST(MULTISET(SELECT l.order_id,l.line_item_id, l.unit_price,l.quantity, [...]

OE OC_CORPORATE_CUSTOMERS (view) — 1.4%

wikibot View OE.OC_CORPORATE_CUSTOMERS Source CREATE OR REPLACE VIEW OE.OC_CORPORATE_CUSTOMERS AS SELECT c.customer_id, c.cust_first_name, c.cust_last_name, c.cust_address, c.phone_numbers,c.nls_language,c.nls_territory, c.credit_limit, c.cust_email, CAST(MULTISET(SELECT o.order_id, o.order_mode, MAKE_REF(oc_customers,o.customer_id), o.order_status, o.order_total,o.sales_rep_id, CAST(MULTISET(SELECT l.order_id,l.line_item_id, [...]

OE INVENTORIES (table) — 1.4%

wikibot Table OE.INVENTORIES Description Tracks availability of products by product_it and warehouse_id. Columns Column Data Type Nullable Default Description PRODUCT_ID NUMBER(6, 0) not null Part of concatenated primary key, references product_information.product_id. WAREHOUSE_ID NUMBER(3, 0) not null Part of concatenated primary key, references warehouses.warehouse_id. QUANTITY_ON_HAND NUMBER(8, 0) not null Primary Key Primary Key Columns INVENTORY_IX WAREHOUSE_ID, PRODUCT_ID Indexes Index Type Columns INV_PRODUCT_IX PRODUCT_ID [...]

IX AQ$_ORDERS_QUEUETABLE_N (sequence) — 1.1%

wikibot Sequence IX.AQ$_ORDERS_QUEUETABLE_N Sequence Start Value Max. Value Increment Cache Values Cycle CREATE SEQUENCE IX.AQ$_ORDERS_QUEUETABLE_N INCREMENT [...]

OE PRODUCTS (view) — 1.1%

wikibot View OE.PRODUCTS Source CREATE OR REPLACE VIEW OE.PRODUCTS [...]

OE OC_INVENTORIES (view) — 1.1%

wikibot View OE.OC_INVENTORIES Source CREATE OR REPLACE VIEW OE.OC_INVENTORIES [...]

OE SYDNEY_INVENTORY (view) — 1.1%

wikibot View OE.SYDNEY_INVENTORY Source CREATE OR REPLACE VIEW OE.SYDNEY_INVENTORY [...]

OE STYLESHEET_TAB (table) — 1.1%

wikibot Table OE.STYLESHEET_TAB Columns Column Data Type Nullable Default Description ID NUMBER null STYLESHEET OE.XMLTYPE [...]

OE PRODUCT_DESCRIPTIONS (table) — 1.1%

wikibot Table OE.PRODUCT_DESCRIPTIONS Description Non-industry-specific design, allows selection of NLS-setting-specific data Columns Column Data Type Nullable Default Description PRODUCT_ID NUMBER(6, 0) not null Primary key column. LANGUAGE_ID VARCHAR2(3) not null Primary key column. TRANSLATED_NAME NVARCHAR2(150) not null TRANSLATED_DESCRIPTION NVARCHAR2(4000) not null Primary Key Primary Key Columns PRD_DESC_PK PRODUCT_ID, LANGUAGE_ID Indexes Index Type Columns PROD_NAME_IX TRANSLATED_NAME Check Constraints Check [...]

OE TORONTO_INVENTORY (view) — 1.1%

wikibot View OE.TORONTO_INVENTORY Source CREATE OR REPLACE VIEW OE.TORONTO_INVENTORY [...]

OE WAREHOUSES (table) — 1.1%

wikibot Table OE.WAREHOUSES Description Warehouse data unspecific to any industry. Columns Column Data Type Nullable Default Description WAREHOUSE_ID NUMBER(3, 0) not null Primary key column. WAREHOUSE_SPEC SYS.XMLTYPE null WAREHOUSE_NAME VARCHAR2(35) null LOCATION_ID NUMBER(4, 0) null WH_GEO_LOCATION MDSYS.SDO_GEOMETRY null Primary key column, references hr.locations.location_id. Primary Key Primary Key Columns WAREHOUSES_PK WAREHOUSE_ID Indexes Index Type Columns WHS_LOCATION_IX LOCATION_ID Foreign Keys Relation [...]

OE OC_PRODUCT_INFORMATION (view) — 1.1%

wikibot View OE.OC_PRODUCT_INFORMATION Source CREATE OR REPLACE VIEW OE.OC_PRODUCT_INFORMATION [...]

OE PRODUCT_PRICES (view) — 1.1%

wikibot View OE.PRODUCT_PRICES Source CREATE OR REPLACE VIEW OE.PRODUCT_PRICES [...]

OE CUSTOMER_TYP (type) — 1.1%

wikibot Type OE.CUSTOMER_TYP Source CREATE OR REPLACE TYPE customer_typ AS OBJECT ( customer_id NUMBER(6) , cust_first_name VARCHAR2(20) , cust_last_name VARCHAR2(20) , cust_address cust_address_typ , phone_numbers phone_list_typ , nls_language VARCHAR2(3) , nls_territory VARCHAR2(30) , credit_limit NUMBER(9,2) , cust_email VARCHAR2(30) , cust_orders [...]