Navigation¶

• Main Page
  

• Random Page
• Create a new Page
• All Pages
• Categories
• Navigation Paths
  

• Administration
• File Management
  

• Create Account
  

Search the wiki
»

Search in all Namespaces and all Categories
Search Files and Attachments

Filter by Category

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 — 17.4%

[...] 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) [...]

WikiMarkup — 2.8%

[...] Boxed Wraps content in a box : Indentation Indentation Each ':' sign at the beginning of a line indents content one level Lists You can create an unordered or ordered lists using * and # characters, for example: WikiMarkup Output Notes * List element * Another element, which continues on a new line * A third element List element Another element, which continues on a new line A third element Always keep an empty line after a list [...]

Purchasing PurchaseOrderDetail (table) — 2.2%

[...] key to PurchaseOrderHeader.PurchaseOrderID. PurchaseOrderDetailID int not null Primary key. One line number per purchased product. DueDate datetime not null Date the product is expected to be received. OrderQty smallint not null Quantity ordered. ProductID int not null Product identification number. Foreign key to Product.ProductID. UnitPrice money not null Vendor's selling price of a single product. LineTotal Per product subtotal. Computed as OrderQty * UnitPrice. ReceivedQty decimal(8, 2) not null Quantity actually received from the vendor. [...]

OE ORDER_ITEMS (table) — 2.2%

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

OE ORDERS (table) — 2.2%

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 - bad credit, - ORDER_TOTAL NUMBER(8, 2) null CHECK constraint. [...]

Production TransactionHistory (table) — 1.7%

[...] Purchase order, sales order, or work order identification number. ReferenceOrderLineID int not null ((0)) Line number associated with the purchase order, sales order, or work order. TransactionDate datetime not null (getdate()) Date and time of the transaction. TransactionType nchar(1) not null W = WorkOrder, S = SalesOrder, P = PurchaseOrder Quantity int not null Product quantity. ActualCost money not null Product cost. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_TransactionHistory_TransactionID [...]

Production WorkOrder (table) — 1.7%

[...] Column Production.WorkOrderRouting WorkOrderID WorkOrderID Triggers Trigger Type iWorkOrder ON INSERT uWorkOrder ON UPDATE Trigger iWorkOrder CREATE TRIGGER [Production].[iWorkOrder] ON [Production].[WorkOrder] AFTER INSERT AS BEGIN DECLARE @Count int; SET @Count = @@ROWCOUNT; IF @Count = 0 RETURN; SET NOCOUNT ON; BEGIN TRY INSERT INTO [Production].[TransactionHistory]( [ProductID] ,[ReferenceOrderID] ,[TransactionType] ,[TransactionDate] [...]

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 CUSTOMERS (table) — 1.7%

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 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, [...]

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

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, [...]

OE OC_ORDERS (view) — 1.4%

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, [...]

Sales SalesOrderDetail (table) — 1.4%

[...] Sales.SpecialOfferProduct SpecialOfferID SpecialOfferID Triggers Trigger Type iduSalesOrderDetail ON INSERT UPDATE DELETE Trigger iduSalesOrderDetail CREATE TRIGGER [Sales].[iduSalesOrderDetail] ON [Sales].[SalesOrderDetail] AFTER INSERT, DELETE, UPDATE AS BEGIN DECLARE @Count int; SET @Count = @@ROWCOUNT; IF @Count = 0 RETURN; SET NOCOUNT ON; BEGIN TRY -- If inserting or updating these columns IF UPDATE([ProductID]) OR UPDATE([OrderQty]) OR UPDATE([UnitPrice]) OR UPDATE([UnitPriceDiscount]) [...]

OE PRODUCTS (view) — 1.1%

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

OE ORDER_ITEM_TYP (type) — 1.1%

wikibot Type OE.ORDER_ITEM_TYP Source CREATE OR REPLACE TYPE order_item_typ AS OBJECT ( order_id NUMBER(12) , line_item_id [...]

OE TORONTO_INVENTORY (view) — 1.1%

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

OE SYDNEY_INVENTORY (view) — 1.1%

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

OE OC_PRODUCT_INFORMATION (view) — 1.1%

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

OE ORDERS_SEQ (sequence) — 1.1%

wikibot Sequence OE.ORDERS_SEQ Sequence Start Value Max. Value Increment Cache Values Cycle CREATE SEQUENCE OE.ORDERS_SEQ INCREMENT [...]

OE ORDERS_VIEW (view) — 1.1%

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

OE PRODUCT_PRICES (view) — 1.1%

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

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 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 CUSTOMERS_VIEW (view) — 1.1%

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

OE DEPTVIEW (view) — 1.1%

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

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 ACCOUNT_MANAGERS (view) — 1.1%

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

OE BOMBAY_INVENTORY (view) — 1.1%

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

OE OC_INVENTORIES (view) — 1.1%

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